The mssql database you are currently using is slow to search You want to improve the speed of this slow search speed.
php, mysql, word press, bootstrap, jquery , ajax, html5 (모바일웹, 앱) 기술 우대
나중에 제가 좀 시간이 나면 bidding 해 볼까요? ㅋㅋ 요즘 너무 바빠서... 중국도 다녀와야 하고... 뭐 랜딩페이지 하나 만들어주세요, 한장 만들어달라는 얘기. 쇼핑카트 만들어 주세요, 이런일들이 많아요. 뽀샵 사진을 짤라주세요. 이런 일도 있고. ㅋㅋㅋ 좀 비싼일들은 ajax chatting, asp.net, php 로 사이트 구축, php, jQuery, java, AJAX 이런거 복합적으로 섞어서 1년동안 일해야 하는 것도 있고.... 이런 건 제가 bidding 자체를 제가 못하겠죠. 어느정도 불러야 하는지도 모르니.... 그누보드 스킨만 갖고도 충분히 구축할수 있는 정도 사이트, 현재 bidding 이 대략 550만원이네요...
1. 최적화 WORDPRESS 구성 에 VPS(2G) 에 워드프레스 테마(Ajax 모듈 중심 테마) 1개 최적화 ㅡ 적용기술 ( page rule최적화 및 ssl 적용, VarnishㅡNginxㅡphp-FPM, W3 total cache) ㅡ 최적화된 VPS 자동 최적화 ( 정기적 cache 제거 룰 클론으로 적용) ㅡ 테마 Patch 시 linode api 를 활용해서 원격에서 자동 패치 프로그램 지원) ㅡ 테마 적용 플러그인 (bbpress, wptouch, 구글통계, jatpack, w3 total cache, yoast pro..) 2. VPS 추가 및 PATCH 관리 및 기타 이슈관리 지원 ㅡ 1번에서 제작된 snapshot 활용 다수의 VPS 에 적용 ㅡ 다수의 VPS 에 테마 PATCH 및 자동 패치 가능한 Plugin patch 툴로 일괄 적용 * 셋팅된 VPS의 설정(사이트 디자인 포함)은 해당 사항 없음
I'm in need of a skilled database designer and manager who' is confident in English. The project involves creating and maintaining a relational database. Key Requirements: - Advanced knowledge of Relational Databases - Proven experience in database design and management - Must be be fluent in English Experience with: - Customer data management or transaction records (preferred but not mandatory) I'm looking for someone who can work on this project with no strict time limit.
...Oracle EBS customers within the manufacturing sector in USA. This is a sizable task as it requires the creation of a list featuring more than 500 companies. In the details you collect for each organization, I'd like to see the following: - Company Name - Contact Person Name - Contact Person Email. The ideal candidate for this task would be someone who is proficient in data mining and possesses broad knowledge of Oracle EBS customers in the manufacturing, retail, automotive industry. Prior experience in CRM database creation would be an added advantage. It's essential that all information gathered adheres to privacy and data protection laws, ensuring a legally compliant list. So, a freelancer with a keen understanding of these laws would be highly pref...
I'm in urgent need of a Python Django developer to help me deploy my old website files on Namecheap. Here's a rundown of the tasks and requirements: - Deploying old website files on Namecheap: I need you to swiftly and effectively set up and configure the database for my project. - No new development or integrations: You won't be tasked with front-end or API work, just the deployment of the existing files. Your experience with Django and database setup are paramount. Time is of the essence, so I need a professional who can work efficiently and effectively.
I'm looking to create a detailed list in Excel from the website AND filtered by clicking on 'Hardware' under 'Products' which is on the left side in the 'Filter' section. The list should have two columns - the first for the Company Name and the second for the Description available on the website. Key Requirements: - Copy the Company Name into Column 1 and the Description into Column 2 of the Excel sheet. - Description should be directly copied from the provided URL. Ideal Skills and Experience: - Proficient in Excel and web scraping. - Attention to detail to ensure accurate data transfer. - Previous experience with similar projects would be advantageous.
I’m seeking a data expert to scrape a specific database and transfer all available fields into an Excel (.xls) file. The database consists of approximately 150,000 entries. Each record includes data such as name, business name, contact information, date of foundation, etc. Ideal Skills: - Strong experience in Web Scraping - Proficiency in transferring data into .xls format - Attention to detail to ensure all available fields are captured Purpose and Deliverable: - The objective of this project is to use this information for data analysis. - The final output will be an Excel (.xls) formatted file containing each scraped database entry. Operation Specifics: - You would be required to locate and scrape the database by Zip codes. - A full export of all...
I need an experienced HTML developer to provide guidance on webpage code. The key goals are to add an auto-population feature and convert an existing Pop Up into a Modal. Key Requirements: - Provide the framework for an auto-population feature in the HTML ...VAR (variable) included in the "Autopop ". The autopop will then open a specific Menu item based on the VAR and the Script AutoPop Matrix. - Take the existing birthday pop-up (included at bottom of (HTML to update.txt.) and convert it into a modal but include all of the same criteria for population. Ideal Skills and Experience: - Strong expertise in HTML, JavaScript and possibly AJAX - Prior experience in implementing auto-population features in webpages - Ability to work on the project and deliver within 1 weeks t...
I'm looking for someone to compile a list of hedge funds in the United States. The purpose of this list is to network with these hedge funds, so it's important that the list is focused on specific investment strategies. Key Requirements: - This list should only include hedge funds that focus on specific investment strategies. - For each hedge fund, I'm looking for basic contact information. This would include the name of the fund, a contact email, and perhaps a phone number. Ideal Skills and Experience: - Research skills to find and verify the information. - Understanding of hedge funds and their investment strategies. - Excellent organizational skills to present the information clearly.
I am looking for a digital media marketing expert to assist in driving brand awareness and generating leads for our engineering company. The campaign is targeted towards a B2B audience, particularly engineers, real estate developers, and industries. Key Points: - **Objectives**: The main focus of the campaign will be on increasing brand awareness and generating leads. - **Target Audience**: It's crucial that the freelancer understands how to tailor content and ads to effectively resonate with engineers, real estate developers, and industry professionals. - **Industry Experience**: Knowledge of B2B marketing, especially within engineering, real estate, and industrial sectors will be highly beneficial. - **Platforms**: The primary platforms for this campaign will be LinkedIn and Faceb...
...Feyenoord, they should automatically get access to the players from that league. A league can only start if there is at least one real user active in that league. There are 10 leagues in my database. Nothing should happen if there is no active user linked to a league/team. Now, here's the exciting part. Every match should be generated at 00:00 with certain random variables. So, for example, if a player is in League 1, I want all matches in that league to be generated. I've created an example of how I want to visually present this to the user. Check out the example here: Online Soccer Game Example. Choose Ajax and Feyenoord, and start the match for a preview. Changes must be for More details: What programming language is your
I'm in need of a skilled developer to create a robust course management database for our educational institution. Key Functionalities: - Student Registration and Enrollment: The database should be able to store and manage student information. - Grades and Transcripts Management: The system should have a feature to track, store, and manage students' grades and transcripts. - Attendance Tracking: The database needs to have a reliable attendance tracking system. - Multiple Courses: The system should be designed to manage multiple courses efficiently. Expectation: - The database should be able to handle 50-100 users accessing it simultaneously. - It needs to be user-friendly, secure, and scalable for future expansion. - Preferably, a responsive design w...
I'm looking for an expert with exceptional Sequel database administration skills on a Windows environment. Your main task will be to handle executing regular exports from our Sequel Database to Excel, performing updates in Excel, and subsequently updating the Sequel Database with the altered data. Skills and Tasks; - Mastery in handling Sequel Database on Windows - Familiarity with Data Modeling and Design - Proficiency in exporting and updating database information via Excel - Being responsive and flexible as the frequency of this task may change. Initially, I will need it done daily for a week. Afterwards, it will be an as-needed basis for remote support. Experience in Performance monitoring, tuning, and database backup would be a bonus....
...specifics of the data extraction are as follows: - I require product details and price information from the site. - The main task involves capturing a comprehensive car database, including all car brands and models present on the site. The focus here is on the complete car directory, not just specific brands or models. If you have experience in web scraping, particularly in the automotive sector, this project is for you. Accuracy and completeness are key, as the success of the project hinges on the comprehensive nature of the dataset. I attached RAR file (Scraping code). by running this script, fetching yourself full database of cars. pocketbase queries to supoprt filters and run them on pocketbase server side routes, so that they can be used to feed data to views. (...
I'm looking for an experienced SQL Developer with a strong background in MS SQL and data warehousing. You'll be responsible for designing and optimizing a new database system. The project involves working with Microsoft SQL Server Analysis Services in an Azure SQL environment. Key Responsibilities: - Designing a new database system - Optimizing queries for better performance - Utilizing Microsoft SQL Server Analysis Services - Ideal Candidate: - Strong experience in database design and optimization - Proficiency in SQL, specifically with Microsoft SQL Server - Familiarity with data warehousing concepts - Experience with Microsoft SQL Server Analysis Services - Experience working in an Azure SQL environment - Expert coding skills in SQL coding - E,perince ...
I have a Word document with a list that I'd like to be transformed into a static flow chart. The flow chart should cater to a broad audience including team members, management, and clients. I've attached references. Key requirements: - Convert the content of the Word document into an easy-to-understand, effective static flow chart. - Ensure the flow chart is comprehensive, clear, and visually engaging to cater to a diverse range of readers. Ideal Skills and Experience: - Proficiency in flowchart software. - Strong analytical and visualization skills. - Experience in creating static flowcharts. - Understanding of how to cater to a multi-audience format. Please suggest your approach for this project in your bid.
I am in the need of an experienced professional to help me set up 6 to 10 cold email accounts. This project does not entail content creation; I am well-prepared and have all the content ready. Your tasks would include, but are not limited to: - Email Provider Recommendation: While I do not have a particular email provider in mind, I'm open to your suggestion based on your expertise and previous experiences. Gmail, Outlook, or Yahoo Mail could be a choice, but I'm not limited to these. - Account Configuration: Setting up 6 to 10 email accounts ready for a cold email campaign. Ideally, you have a strong background in digital marketing, specifically email marketing, with a proven track record in similar projects. Furthermore, you should have an excellent understanding of...
We do drop shipping or Freight Business. And I wanted to have our own tracking portal tool, No need any API the Tracking Number will be generated and updated Manually from some Admin por...GPS coordinate, QR code of the GPS coordinate. - Shipping Label: Origine Address, Destination Address, Order No (From QuickBook), Reference_PO, Weight, Dimenssions, Tracking Number, Tracking BarCode, Delivery instruction, Package No, timestamp - Tracking Tracking_Number, Carrier_Tracking_Number, Lot Number, Expected Delivery Day, Customer:FULL Name, Status message, (suggestion) Date and Time, (Auto generated as GMT+1 time), Location, (City, Country) timestamp - Inbound_items: Inbound_tracking, Item_url, Desciption Tracking:Tracking_Number timestamp --...
I am looking for an experienced developer to set up an Airtable Database for me. This project involves creating a systematic way to handle, organize and manage our client information, employee management details, and project tracking. Key tasks include: - Setting up an Airtable Database - Enabling specific functionality such as data import/export - Custom form creation for easy data entry and extraction - Integration with other apps for streamlined operations Ideal Skills and Experience: - Proven experience in using and setting up Airtable databases - Strong understanding of data integration and manipulation - Familiarity with custom form creation - Experience with app integration for seamless data sharing - Knowledge in handling sensitive data with an emphasis on data ...
I am in need of an Excel relational database. The database should have the functionality to enter values automatically from an attached worksheet. The entry of these values will be based on specific criteria, more specifically, column values. Required Skills and Experience: - Strong knowledge and proficiency in Excel - Experience in database creation, management, and optimization - Understanding of data entry and data analysis - Proven experience in creating reporting capabilities within Excel. Using the "Reference data" tab, when the value in Column B is entered in the "Example worksheet" the corresponding values should automatically populate - Tariff code, Duty rate, CPF.
python chrom headless script which will visit given list of URLs/websites aftear each config delay in seconds. script will use different ip in each iteration of list urls visit. it will keep running untill ip list end and start from 1 again. You will suggest from where i will buy rotating ip proxies which not blocked by the urls. Purpose of this script. visit given list of urls with different ip proxies. rotating ip proxies will be fine these are example urls: one is this link :
python chrom headless script which will visit given list of URLs/websites aftear each config delay in seconds. script will use different ip in each iteration of list urls visit. it will keep running untill ip list end and start from 1 again. You will suggest from where i will buy rotating ip proxies which not blocked by the urls. Purpose of this script. visit given list of urls with different ip proxies. rotating ip proxies will be fine these are example urls: one is this link :
...Access developer to create a comprehensive database solution for my business needs. Key Project Details: - I require a robust database with more than 10 tables. - The database should feature data entry forms for easy information input. - It should have advanced error-checking capabilities to ensure data integrity. - Reporting and analytical functionalities are essential for tracking business performance and making informed decisions. Ideal Skills and Experience: - Proficiency in Microsoft Access and database design. - Strong track record of developing complex databases with user-friendly interfaces. - Experience in data validation, error checking, and report generation. - Excellent understanding of business processes and needs for effective database...
I'm in need of a skilled web developer to help me with the following tasks: - HTML coding - Implementing AJAX - Developing JavaScript elements The project involves creating a website that caters to the general public. The key functionalities I'm looking for are: - Data submission and processing - Real-time updates - Dynamic content generation Ideal candidates for this project will have - Proficiency in HTML, AJAX and JavaScript - Previous experience in developing websites aimed at general public - Ability to deliver on data processing, real-time updates, and dynamic content generation. Hello to you freelancers, I programmed an availability check on one page. If a user enters a street, zip code or city into the text field on the page, they will receive the respe...
I'm currently in the process of creating a cost items database for residential electrical service items. I would like someone who has previous experience with similar work. I will need the database to be input into my management software called "Contractor Foreman". This database will need assemblies of materials assigned to each task. Key Requirements: - Cost estimates for lighting fixtures, electrical outlets, circuit breakers, and all other necessary items for a residential electrical service and remodel with adjustments for different types of condition that can e encountered. - A detailed breakdown of costs for each category is essential. - Extensive experience in providing accurate and reliable cost estimates for electrical systems is a must....
...reliable Python expert who can create a script that automates text extraction from specific PDF files and insert results into a PostgreSQL database. This tool is essential for a new automation process and accuracy is vital. The successful candidate will develop a script that: - Accepts a list of PDF objects (standardized format, example files will be provided) - Performs text recognition and extracts text from the listed PDFs - Inserts the extracted results into a PostgreSQL database In terms of output format, the extracted text needs to be integrated into a PostgreSQL Database. I'm open to suggestions on the specific table structure for this database. Should there be file reading errors or instances of unsuccessful text extraction, the script...
...that do not meet these criteria will not be considered, as well as applications that are submitted within 30 minutes of this task being posted - as this will indicate an automated response or insufficient understanding of the requirements. The Task We are in the process of creating a comprehensive English language database of literary quotations, either in native English or a reputable translation into English - from antiquity through to the 21st Century. We can supply a list of possible authors and require research into each of these authors, with the identification of key original or attributed quotations (maximum 250 words) in each case. The identification of quotation authors that lie outside our identified base will be highly regarded. The required response ...
I'm in need of an experienced PostgreSQL Database Administrator to assist with a few key tasks. - Connecting to Database: I need assistance in establishing a connection to the database. This is a crucial task that requires a skilled professional who can set up the necessary configurations and ensure seamless communication between the database and applications. Your expertise in PostgreSQL is paramount, especially having worked with different versions (9.6, 10, 11,16). A deep understanding of database management and connectivity is essential, as well as experience in working with Windows as the operating system of the database. I need remotely to connect to database. Locally its working. is not properly set.
Scrape specfic business Email Database from google map and ther online directories
We are looking for a skilled database architect to design and manage the database architecture of our social media platform . The ideal candidate will have a deep understanding of database management systems and data modeling techniques. Feature in application : 1. User details 2. Upload a video feature like shorts and reels 3. Post a content like Linkedin 4. There are different types of video's category 5. Likes, comments, share 6. Other features Relevant skills for this role include: - Proficiency in database management systems in PostgreSQL - Expertise in data modeling and schema design - Strong understanding of database optimization techniques - Hands-on experience with SQL queries and performance tuning - Knowledge of database securit...
As a growing organization, we are seeking skilled administrators to join our team. We are looking for passionate individuals in three specializations - office administrators, HR administrators and database administrators. The ideal candidates should possess the following: - Strong communication skills, - Proficiency in Microsoft Office Suite, and - Experience with database management. Applications should include: - A cover letter explaining why you're the right administrator for us, - Educational certificates to validate your qualifications, and of course, - A detailed CV showcasing your previous experiences. Looking forward to receiving your applications and potentially welcoming you to our driven team. Apply now and make a difference!
I'm looking for a database design expert to help me create a new database. The specifics are a bit unclear at this stage, so I'll rely on your expertise to help me determine the best database type and functionality. Key Responsibilities: - Partner with me to decide on the most suitable database type, considering the intended purpose - Design the database from scratch, ensuring it's optimized for efficient storage, retrieval, and maintenance - Implement any necessary functionality to support the database's purpose Ideal Freelancer: - Proven experience in database design, particularly in creating new databases - Strong knowledge of various database types (relational, NoSQL, object-oriented) - Ability to collaborate and c...
Hi! Your job 1. Go to a website (url in brief) every day to every other day 2. On that website click a link to open another website. This website is NOT live/active yet. 3. Open the list of names we have (about 30 names) 4. If one of the names from our list is listed on the website then send an email to us (not to the person) 5. Allow us to add names to the list, change where the email is sent, change body of email and when the scraping starts/stops as well as frequency (daily or every other day).
...customer service aspect of my business and to take charge of a small database (containing up to 1,000 records). Key responsibilities will include: - Customer Service: Responding to client enquiries, resolving user issues, and maintaining high customer satisfaction levels. - Database Management: Handling information pertinent to the customer service role, conducting regular updates, ensuring record accuracy, managing data privacy, and maintaining overall data integrity. The ideal candidate would have: - Prior experience in a customer service position, demonstrating excellent communication and problem-solving skills. - Proficiency in database management, more specifically with small scale databases. Knowledge of database software will be an added advantage....
We are seeking an experienced developer to integrate OpenAI GPT into our existing database system (Zoho CRM) to enable natural language queries for investor searches. Users on our website will describe their company and transaction details, and the GPT will summarize and request additional information. Based on this, the GPT will score investors using a customizable algorithm and provide a CSV list of the top 100 matches. Users interested in further details must sign an NDA and fee agreement via an automated system, with their information and preferences automatically transferred to our CRM database. Key Project Details: User Interaction on Company Website: Users will describe their company and transaction details on our website using natural language queries. The G...
Error establishing a database connection This either means that the username and password information in your file is incorrect or that contact with the database server at localhost could not be established. This could mean your host’s database server is down. Are you sure you have the correct username and password? Are you sure you have typed the correct hostname? Are you sure the database server is running? If you are unsure what these terms mean you should probably contact your host. If you still need help you can always visit the WordPress support forums.
I need a simple code to conect a accdb file with password in visual basic 6. It´s very simple. I need a code working with Visual Basic 6 SP6 The connection need to be by code.
I'm in need of a talented developer proficient in VB6 application conversion to both iOS and Android platforms. The main task will involve modernizing a data analysis VB6 application, bringing it to a mobile platform while preserving its core functions and unique aspects. Key tasks: - Convert VB6 application to a hybrid mobile app for both iOS and Android. - Please make an educated suggestion about what should be preserved since I didn't indicate specific features from the original VB6 app. - The application's primary purpose is data analysis, which needs to shine in the mobile version. Ideal skills: - Proficient in VB6 and mobile app development. - Good understanding of data analysis applications. - Nice to have: a portfolio of similar completed projects.
I need help to sanitize my online database to eliminate duplicate entries. My primary data source is an online database which has become cluttered with repetitive information. This hampers the overall efficiency and creates error in my outputs. I urgently require a skilled data entry expert with a strong competency in data cleaning, in particular, the elimination of duplicate entries. Your role will involve systematically reviewing the database, identifying duplicates and then removing or merging this data. Familiarity with online databases and previous experience in data cleaning is a necessity for this task.
I'm in need of assistance for setting up a PostgreSQL database on my backend GitHub website. The primary purpose of this database is to store user data. Given the nature of my website, it's essential that the database supports concurrent access efficiently. The ideal professional will have: - Proficiency in setting up PostgreSQL databases. - Experience with integrating databases into backend GitHub projects. - Knowledge of concurrent access management in databases.
I'm in need of a modern and minimalist text-based logo designer. I need a freelancer to convert this bitmap logo ( ) into a vectorized logo for Corel Draw version 9.0 . There is a sample of our company logo in Corel Draw v9.0 ( sample ). After that, create a 3D png logo, as the sample of our...vectorized logo for Corel Draw version 9.0 . There is a sample of our company logo in Corel Draw v9.0 ( sample ). After that, create a 3D png logo, as the sample of our Totem3D logo ( sample ) . Summary: We need the "TRIX" logo in vector Corel Draw v9.0 and the TRIX logo in 3D png in high definition and large size. If you have another logo or shape suggestion for the logo it would be appreciated.
I have an Android application with a user base of less than 10,000 users. Currently, I am displaying Banner ads, Interstitial ads, and Rewarded video ads from AdMob. I'm not entirely sure if I have implemented AdMob mediation correctly. Key tasks include: - Reviewing my current Android App & AdMob Ads - Providing suggestions on how to optimize revenue generation. - Verifying and potentially setting up AdMob mediation. I'm looking for a professional who: - Has a proven track record of optimizing AdMob revenue. - Is knowledgeable about AdMob mediation and can verify its implementation. - Can provide concrete, actionable suggestions for improving revenue generation from my app. If you have the expertise in AdMob, please reach out.
I need help to sanitize my online database to eliminate duplicate entries. My primary data source is an online database which has become cluttered with repetitive information. This hampers the overall efficiency and creates error in my outputs. I urgently require a skilled data entry expert with a strong competency in data cleaning, in particular, the elimination of duplicate entries. Your role will involve systematically reviewing the database, identifying duplicates and then removing or merging this data. Familiarity with online databases and previous experience in data cleaning is a necessity for this task.
In Your proposal please mention the website names where you will be posting our article, we prefer home decor, interior design websites and must have good reputed ranking, without mention of websites , pls dont apply. I'm looking for an experienced SEO expert who can help me improve my website's search engine rankings. The primary task will be to obtain backlinks from websites with a domain authority of 70 and above. The goal is to increase the visibility of my landing pages among the general public. As such, the backlinks need to be strategically placed and relevant to the context of the content they are linking to. The ideal candidate should have: - Proven experience in SEO and link building - Familiarity with high domain authority websites - An understanding of how searc...
I need assistance troubleshooting an Ajax call. Specifically, there's an issue with the condition logic--validating user authentication status. I am seeking a skilled professional who has: it only front end work - Expertise in integrating API - Extensive experience in Ajax - Understanding of condition logics - Knowledge in remote desktop support This task requires 1 to 2 hours of remote work. Please ensure you're available for this duration. Your assistance will be highly appreciated!
I'm in need of a professional who can create a straightforward database with a user-friendly GUI for Windows. Key Requirements: - The database should be able to store and retrieve data efficiently. - It should feature a GUI for easy interaction. Ideal Skills and Experience: - Proficiency in Windows database development. - Prior experience in designing user-friendly GUIs. - Strong knowledge of data storage and retrieval techniques. Please let me know about your relevant experience and a rough estimate of the time and cost required for this project. Thank you.
A reliable database migration specialist (with previous email campaign setup skills) with their own computer and internet to work from home. You will be working with the Microsoft SQL server, experience is preferred but not essential to be an expert. Anyone with generic database experience (with different databases) can also apply. Skills already acquired from previously doing this work: - Understand database schema - understand database structures - create database tables based on bespoke requirements (training included) - Working with relatively large sets of data - has exporting skills into SQL - Excel and VBA, - Has experience in different querying languages - Proficient in Microsoft SQL Server Management Studio - Familiarity with Windows OS - ...
As a beginner level MySQL user, I am seeking someone to sit with me (virtually) for approximately 2-3 hours to aid me in running certain MySQL commands with some provided databases. Beyond this, I need assistance in creating a new database from scratch. The session will be conducted via Zoom, and it's vital that you have the requisite MySQL software and databases already installed on your own device. My needs during the call include: - Writing MySQL commands - Understanding MySQL commands - Creating a fresh MySQL database Ideal freelancer for this task would have a strong command of MySQL and proven experience in teaching or tutoring, as well as excellent communication skills in English.
