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의 설정(사이트 디자인 포함)은 해당 사항 없음
Build an ISO for a raspberry pi (with cellular notecard) to scan for unique cell phones in a specific range and log the unique phone ID and timestamps/ping (distance) from the raspberry pi and store in mysql database using cellular adapter.
I'm in need of a proficient expert who can assist me with running queries on DuckDB using data originating from Amazon S3. This task primarily involves: - Interacting with semi-structured data such as XML and JSON - Processing a substantial data volume ranging from 1GB to 1TB The ideal freelancer should have the following capabilities: - Deep understanding and experience with DuckDB and Amazon S3 - Strong skills in handling and querying semi-structured data - Experience in managing and processing large volumes of data Please note: it's critical that the freelancer have experience with managing these sorts of tasks previously and has a solid understanding of large volume data manipulation.
...| |-- Sign Up with Google | |-- Sign Up with Facebook | |-- Sign Up with Email |-- My Account Page | |-- Design Improvements |-- User Profile | |-- Customer Personal Info | |-- View and Edit Profile Information | |-- Address List - Add new /Edit and delete | |-- Phone Number Change Option | |-- Order History | |-- View Past Orders | |-- Reorder or Return Items| | |-- Privacy and Security | |-- Change Password |-- Customer Support | |-- FAQ Section | |-- Contact Options (Email, Phone, Live Chat) | |-- Notifications | |-- Email and SMS Notifications | |-- New Login verification | |-- Order Status | |-- Delivery Status |-- Check Out Page | |-- New Customer Customer Can Reach to Checkout Page without Sign up |...
...analyze the problem, and if possible, solve it. According the Masterstudy plugin support, it´s running. So, could be other problems. this is the error message Error calling GET : (403) <!doctype html> <html> <head><meta charset='utf-8'> <title>Error • Udemy</title> </head> <body> Forbidden <script>(function(){if (!) return;var js = "window['__CF$cv$params']={r:'885cdcdf3f9f9180',t:'MTcxNjA0NTk1Ny4wMzIwMDA='};_cpo=('script');_cpo.nonce='',_cpo.src='/cdn-cgi/challenge-platform/scripts/jsd/',('head')[0].appendChild(_cpo);";var _0xh = ('iframe'); = 1; = 1; = 'absolute'; = 0;
...complete but due to some error while connecting to the database some code is missing and the connection is not completed. You have to find out where the problem is and fix it properly. I will help you in everything ******* I'm seeking a skilled PHP developer to assist with a project that involves fixing a PHP file and combining a Php ,MySQL database. The main tasks for this project include: - Resolving a database connection issue in the PHP file. - Combining the MySQL database in the backend of the PHP file. Your role will be crucial in ensuring that the database is correctly integrated into the PHP file and that the database connection is stable and error-free. The PHP file should be able to successfully communicate with the MySQL ...
I'm in need of a talented financial analyst to create a robust underwriting model for a multi-family property. Key Requirements: - Develop a comprehensive underwriting model for a multi-family property that will assist in calculating the internal rate of return (IRR) and equity multiple. - This model should also include waterfall projections that cover profit splits, with and without preferred returns. Additionally, I require a clear, user-friendly format that is easy to understand for someone without an extensive financial background. The ideal candidate for this project should have a strong background in finance, specifically in multi-family real estate. In summary, the main deliverables for this project are: - Underwriting model for a multi-family property - Multipl...
I'm in need of a skilled photographer with their own studio or location to take professional photos of a variety of home decor items for my ecommerce website. Requirements: - The products that need to be photographed include bedsheets, pillow cases, cushion covers, table covers, and mats. - The photography should be done in a studio setting. - The photos will require col...shots. This project is a great opportunity for a photographer looking to expand their portfolio with professional level home decor images. P.S: refer attached document for the kind of images we want. Please contact only after you've understood the ask here. We are located in Panchkula and if you're available locally, can drop the products or can be couriered to you for the job and you can then re...
...creating an ER diagram, relational schema, database dump, SQL files, and queries for a library database system. Requirements: - ER Diagram: An ER diagram is required with rationalities similar to the example provided in this link: - Relational Schema: Develop a relational schema that effectively models the database. - Database Dump: Provide a database dump for the system. - SQL Files and Queries: The project should include a set of SQL files and queries that effectively interact with the database. - Managerial Queries: Develop a minimum of 20 managerial queries that will be used to analyze and manage the library database. Deadline: This project must be completed by Monday. Ideal Skills: - Proficiency in database design and SQ...
I'm in need of a skilled photographer to take professional photos of a variety of home decor items for my ecommerce website. Requirements: - The products that need to be photographed include bedsheets, pillow cases, cushion covers, table covers, and mats. - The photography should be done in a studio setting. - The photos will require color correction, but background remo...shots. This project is a great opportunity for a photographer looking to expand their portfolio with professional level home decor images. P.S: refer attached document for the kind of images we want. Please contact only after you've understood the ask here. We are located in Panchkula and if you're available locally, can drop the products or can be couriered to you for the job and you can then re...
I have 3 issues on my website that need to be resolved. The site is built on HTML5 and the problems pertain to jQuery. Tasks: - Diagnose and fix the jQuery issues - This includes addressing issues related to jQuery and Bootst...Tasks: - Diagnose and fix the jQuery issues - This includes addressing issues related to jQuery and Bootstrap - Ensure all animations are working as intended - Fix any event handlers that are not functioning correctly I'm seeking a skilled web developer with expertise in: - HTML5 - jQuery - Bootstrap - Proficiency in diagnosing and resolving common issues encountered with jQuery - Experience with AJAX requests and event handling in web development. If you're confident in your ability to troubleshoot and debug HTML5 and jQuery issues, I'd...
...complex backend development and database integration tasks and run code as offline. Key Responsibilities: Develop, test, and maintain robust, scalable, high-quality software solutions. Design and implement new features and functionality. Write clean, maintainable, and efficient code. Develop RESTful APIs to support front-end functionality. Integrate user-facing elements developed by front-end developers with server-side logic. - In-depth understanding and experience of backend operations using Python Django. - Managing and integration of the database with the application. - Maintenance and improvement of existing codebase for optimal functionality. Desirable Skills: - Proven experience in Python Django for backend development. - Hands-on experience in database ...
I've compiled a comprehensive global leads database with 8 million entries. The database includes a variety of details such as name, email, contact number, website, profession, and even Instagram username. - **Purpose**: This database is specifically designed for sales leads generation. It's meant to help businesses and organizations reach out to potential customers and grow their sales. - **Categorization**: The leads are not just categorized by one specific filter. Instead, they're a mix of different categories from various industries, countries, and professions. This eclectic mix provides a wide range of opportunities for potential buyers. - **Delivery Method**: I'm looking to sell this database through a CSV file, online access to the...
Commercial real estate agency database of GCC
About Plesk hosting upgrading the database from MariaDB 10.1 to 10.3 i would like to upgrade the database from MariaDB 10.1 to 10.3 for my hosting however, my hosting have a lot of client website in it, just would like to know if this upgrade will not affect the existing database thanks
Self Managed Home Care Providers Database
Need to do tamil typing :- using Google Transliteration or any other transliteration tool. For example For the words -"என்ன செய்கிறாய் " , you have to type 'yenna seigiraai' and to use any transliteration tool to convert to tamil and return as a docx. or google docs. Totally need to type 30 pages . A sample page is attached.
...While the specifics weren't included, I'm open to suggestions and recommendations based on your experience. We are a 1 product store, with a recurring Monthly rental. We need to be able to add a flat shipping cost to our product. We need to add specific details to the transaction , such as : Date required and measurements on payment form Request for call back where they enter the date and time Return/refund request submission form A page to add product videos A members only page (after payment ) that gives access to tutorial videos AI chatbot (if possible ) Ideal Skills: - Proficiency in Wix: You should have a proven track record of working with the Wix platform, understanding its nuances, and being able to utilize its features to their full potential. - Web...
I'm seeking a data entry specialist with a knack for precision to type data from PDFs into an online database. Key Requirements: - As a data entry specialist, you will be responsible for the accurate and timely entry of data from PDFs into our online database. - The data format should match the original PDFs, with no specific validation rules needed. - The ideal candidate will be detail-oriented, with a proven track record of data entry. If you're someone who enjoys working with data and has an eye for detail, this could be an ideal project for you.
Tengo un error en codeigner con la api de mikrotik , necesito hacer funcionar este script corrigiendo este error: }catch(Exception $e){ return $e->getMessage(); } } } } // Mikrotik API if (!function_exists('mkClient')) { function mkClient() { return new PEAR2NetRouterOSClient(settings()[0]->mkipadd, settings()[0]->mkuser, settings()[0]->mkpassword); } } // Mikrotik API Util if (!function_exists('mkUtil')) { function mkUtil() { return new PEAR2NetRouterOSUtil(mkClient()); } } Class 'PEAR2NetRouterOSUtil' not found
I'm looking to create a comprehensive database of self-managed home care providers in Queensland and Australia to facilitate networking within the industry. Key requirements: - The database should include the provider's: - Name - Address - Email - Prime contact Ideal skills for this project: - Proficiency in data collection and database creation - Familiarity with the home care industry in Queensland and Australia - Organizational skills, to categorize the data by region - Excellent attention to detail, ensuring accuracy in information provided The data should be organized by region for easier networking. I may also require the database to be updated periodically. The collected information should be reliable, up-to-date, and include a diver...
I'm in need of someone with strong experience in PostgreSQL for some critical tasks. - The ideal candidate should be well-versed in PostgreSQL, with a background in both database administration and development. - You must be able to handle complex issues that may arise with the database and be capable of performance tuning when necessary. - I expect you to understand the nuances of PostgreSQL and be able to provide solutions to potential problems with the database. - Any experience with data migration, query optimization and database design will be a plus. Please make sure to include your past work and experience with PostgreSQL in your application. Your detailed project proposals are highly appreciated.
i have one php script which used to load in a few seconds now takes 4 minutes not sure why it suddenly lags need optimised - the mysql query hittin some bottleneck somewhere by looks of it
I am in need of someone who can help me gather email addresses, websites, and phone numbers from the links in the attached spreadsheet. It's crucial that the information you provide is accurate and up-to-date. The test of accuracy will be me sending emails and verifying the company. Any wrong details will need to be collected again unless it is beyond your control (e.g. company has closed down etc.) Automated collection will be erroneous as the data needs to be collected in the following way. use the company names or links from the attached spreadsheet. 2. To copy and paste the company name + UK in the Google search box. The company's operation must be based in the UK as similar names may exist in US as well. 3. Or to click company logo and collect its email addresses, websit...
I'm looking...an existing machine learning model into a Discord bot. The bot should cater to three main functionalities - sending daily race predictions, responding to user queries about race outcomes, and providing real-time race updates. Key Requirements: - Integrate an existing machine learning model into a Discord bot - Implement a feature to send daily race predictions on a specific channel - Develop a query system that effectively responds to user queries about race outcomes - Enable the bot to provide real-time race updates Your Skills: - Proficiency in machine learning model integration with Discord bots - Experience in developing chatbots, particularly for Discord - Knowledge of horse racing and related terminologies - Ability to create an efficient and responsive r...
...potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook to inquire about availability and pricing. Selection and Confirmation: Upon receiving responses, the logistician selects the best courier based on price and availability. The logistician fills out an order form in Excel, converts it to PDF, and sends it to the chosen courier to confirm the shipment. Automate File Transfer Based on Client and Project: Implement a system that automatically transfers the transport query from one file to another in the local drive based on the client and the current project folders. Project Goals: Automate Courier Selection: Develop a way to automatically select suitable couriers from the dat...
I need a proficient database developer (PHP Developer) to create a specialized system for my dental equipment repair company. The database will cater to a sizeable clientele of 5000 customers. The details to be incorporated include: * Equipment type (X-ray machines, Dental chairs, Autoclaves) * Maintenance history * Customer details (Clinic name, number, email address etc.) In order to succeed in this project, you should have: * Strong database creation skills with the ability to account for our unique needs * Experience in the healthcare sector, specifically knowledge of dental equipment * Excellent problem solving and critical thinking skills for effective database design * Understanding of confidentiality requirements given the sensitive nature of the cu...
We are seeking an experienced Flutter developer to integrate 's video and call streaming services along with Firebase database into our existing Flutter application. The primary tasks include implementing 's features for seamless video streaming and call functionality, as well as utilizing Firebase database for efficient data storage and retrieval. The ideal candidate should have prior experience with SDK and Firebase integration. Additionally, the developer will be responsible for updating the app to meet the requirements for submission to both Apple Store and Android Store. If you have the necessary skills and expertise in Flutter development, we'd love to hear from you.
We need the following combination of online database and data entry interface from users + a local MS access file. Online Database and web I terface for data entry We want to have multiple users to view and edit information for subscribers (names) in a database. Those users must be able to login on a web page, with a username and password. All users will see same information. But certain fields, those they will be able to edit, will be visible only to that specific user (and admin). Multiple users must be able to enter data (different) for each subscriber. User must be able to filter certain columns, search in all fields, hide/show columns. Online (on web) visible to users, will be only the fields mentioned in table visible) MS Access (local file) Administrator must...
Hi, I'm Courtney Cunningham from Ride Candy. I'm looking for a proficient web developer to help enhance our website's Slingshot rental return process. - **Interactive Elements**: I require a chatbot for customer support, an interactive map for locating rental return locations, and an animated slider for showcasing our Slingshot models. These elements will make our site more dynamic and customer-friendly. - **UI Improvements**: I'm open to your suggestions on how to improve the user interface. This could involve optimizing the navigation menu, ensuring consistent branding elements throughout the website, and enhancing the overall visual design and aesthetics. - **SEO Optimization**: While I haven't provided specific requirements for SEO, any suggest...
I need a desktop application that can carefully monitor a MySQL database on my Windows system. The app should be able to perform the following functions: - **Monitoring MySQL Database**: The application should constantly monitor my MySQL database and detect when a new record is created. - **WYSIWYG Template Management**: There should be a feature that allows me to manage various WYSIWYG templates. These templates would be used to generate dynamic PDFs based on the new records in the database. - **PDF Generation**: Upon detecting a new record, the application should automatically generate a PDF based on a selected WYSIWYG template. Naming convention based on filed in processing record. Option Password added to pdf. I would like the application to be user-...
I'm looking for an expert to create a web-based CRM database aimed at efficiently storing and managing information. The data I intend to keep include: - Customer contact details - Sales history - Communication logs - Course details - Course Refresher notifications This project also requires the creation of functionalities to: - Add new contacts - Update existing contact information - Track sales performance Ideal freelancers should have substantial experience in CRM database development, with knowledge of implementing web-based solutions. Familiarity with training or course-based entities would be a bonus. Your expertise ought to allow seamless additions, updates, and performance tracking of stored information. Demonstrable success in similar projects will be advanta...
I came across a minor issue on my website on Digital ocean cloud server. Refer the below error information. I need someone who can fix me immediately in an hour. Error 500 PleskExceptionDatabase DB query failed: SQLSTATE[HY000] [2002] Connection refused
I'm looking to test database scraping on a website to extract names and potentially contact emails (if available). The data doesn't necessarily need to be organized or cleaned post-extraction. Ideal Skills: - Proficiency in web scraping tools - Understanding of database structures - Familiarity with handling contact information The data should be organized in an excel and csv based on the desired layout.
I'm seeking a proficient Access Database designer to build an advanced and fully functional task management system. Key Features: - Data Entry Forms: These should be user-friendly and designed for efficiency. - Reporting and Analysis Tools: I need to be able to easily track productivity and analyze task-related metrics. - Data Validation Rules: The system needs to ensure the accuracy of inputted data with stringent validation rules. Structure: The database should consist of 5-10 interlinked tables for comprehensive task tracking and management. Ideal skills and experience for this job would include: - Extensive experience with Access database design, specifically around task management systems. - Strong ability to translate user needs into functional system fe...
...Assistance & Documents Preparation for Company's Current Bank Account. D. Preparation & Filing of Balance Sheet, P & L Accounts, Audit Report, and Director's Report. E. Preparation & Filing of Extract of Annual Returns & Financial Statements (Unlimited Transactions). F. Preparation & Filing of Annual Returns Form AOC - 04 (Financials Related Annual Return). G. Preparation & Filing of Annual Returns Form MGT - 07/07A (Management Related Annual Return). H. Preparation & Filing of Minutes of 04 Board Meeting & Minutes of AGM. I. Preparation & Filing of Income Tax Returns (Company). J. Preparation of Share Certificates (For All Shareholders). K. Preparation & Filing of 07 Mandatory Registers. L. Preparation & F...
I'm seeking an experienced freelancer with strong attention to detail to perform data entry into my database. The data to be entered is text-based and extracted from various sources which may have distinct formats. Below are specifics about the job: - Handling Text Data: The job will entail entering a variety of text data into the designated database. - Format Diversity: The data comes from diverse sources, so it does not adhere to a specific format. The ideal candidate must be adaptable in handling different data formats. - Correcting Discrepancies: The freelancer will need to spot and correct discrepancies or inconsistencies within the data sources. Accuracy and keenness to details will be crucial. Ideal Skills: - Proficient in data entry - Strong attention to d...
I'm looking for a skilled professional to improve the accuracy of my cloud-based database. To achieve this, the tasks at hand include: - Identifying and removing duplicate entries - Standardizing data formats to ensure consistency - Conducting routine data cleaning checks to maintain accuracy Ideal candidates should have: - Proven experience in data cleaning and management - A deep understanding of cloud-based database systems - Strong communication skills as I prefer to get updates and progress reports through an instant messaging app.
I'm searching for a professional who is proficient in SQL coding specifically for MySQL database design. PowerShell scripting or similar would also be beneficial. This is a basic level project taking existing Local government procedures and converting them into SQL based processes. An example of which would be creating a import procedure for traffic count data that is presented in a text format (example attached) Ideal Skills: - Experienced with MySQL Database Design - Well-versed in SQL coding - Ability to simplify complex instructions - PowerShell for anything not possible in SQL This project will demand creativity and intelligence to design procedures that simplify data entry processes. Please only bid if you can offer solutions according to the basic complex...
I am experiencing slow query processing and management issues with large tables in my MySQL database, primarily storing transaction data. I am seeking a DBA specialist to diagnose and resolve these bottlenecks and improve the overall performance of the system. Ideal Skills and Experience: - Proven experience in MySQL database administration and optimization - Knowledge of query execution plans and optimization techniques - Proficiency in managing databases with 10-50 tables - Experience in handling databases primarily housing transaction data Tasks include: - Investigating and diagnosing slow query performance - Optimizing handling of large tables - Implementing necessary changes to enhance overall database performance.
I'm looking for programmers with solid experience in DeFi app development, particularly related to Liquidity pools, Yield farming, and Staking rewards. Key requirements for this project: - Creating a DeFi application that incorporates the above-mentioned features. A fully automated platform, that searches for highest return per transaction, and yet lowest or no risk opportunities in , liquidity pools , arbitrage of all sorts, staking, yield farming and any potential combination to achieve same goal. Ideally, this will be a platform similar to Krystal, but with the added features of above automation based on user request for each item of opportunity. Software must be able to find, on all existing platforms and exchanges these opportunities, evaluate risk factor, and based on us...
...program that will retrieve an xls file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names are, in order: Shipment, Rush order, Mode of delivery, Drop ...
...currently in need of a professional who can assist in completing a database for over +14000 companies. The goal of this project is to generate high-quality sales leads. Key Project Details: - You will be required to include accurate and up-to-date contact information including phone numbers and email addresses. - In addition to the contact details, each company's key contact person's name must also be included in the database. The ideal freelancer for this project will have: - Prior experience with database generation and management. - Proficiency in data mining and web scraping techniques. - Exceptional attention to detail to ensure accuracy of information. - Proven track record in generating sales leads through database creation. This project i...
...an application. This script involves some advanced functions like Windows API calls and file manipulations, and I need it to be converted to C# code. The C# application doesn't need to have a GUI, it only needs to replicate the functionality of the Autohotkey script. API used - GetMenuItemCount EnableMenuItem GetMenuString Ahk method used MouseGetPos CoordMode WinExist WinGetClass LButton::return SendMessage WinGetTitle WinGet WinActivate ControlGetFocus Key requirements: - Convert an advanced Autohotkey script that customizes application behavior to C# code - Ensure the C# code replicates the original Autohotkey script's functionality - No GUI is required in the C# application Ideal skills and experience for this job: - Proficient in both Autohotkey and C# - Ex...
I have a .bin file, i can interpreat the file using a desktop software to get software number and software upgrade number from the file. file exist these info: SW: 2769022101 SW upg.: 2769033803 can you interpreat the bin file and retrive those data from the file. is it possible by php ? if not then if you use...using a desktop software to get software number and software upgrade number from the file. file exist these info: SW: 2769022101 SW upg.: 2769033803 can you interpreat the bin file and retrive those data from the file. is it possible by php ? if not then if you use any other language then will you able to give api in json format so that i will send you file from php application and you will return json response. My budget: 500$ time: 3 days let me know if you can d...
I need the rueda that I am attaching to return Key Requirements: - Experience in 3D animation. - Ability to craft an engaging narrative and visually appealing concept explanation. - Understanding of web design and user experience to ensure the animation complements the website's overall look and feel.
Hi, I need a VPN application with V2Ray protocol. It should support VMESS and VLESS methods. The project can be developed in Swift or Objective-C or Flutter. UI Is attached to the project. Api is ready and all informat...related with api will provided by me. Main features: * User will connect to server using an activation code (Like: 23wsfio3592 (include digit and char)) * User can see the remain days and traffic (Like: 25 Days left, 55 GB remaining) * User can change the server to connect to different locations (Simple combo box to select server) * Server list can show the online percentage (Api will return percentage of total traffic on server) * Api will provided best server to connect (Auto connect) that will choose server automatically by fastest one. Thanks...
