Hi Sunny， 我有个mysql数据库，速度需要提高，你有兴趣和时间帮忙吗？ 这个数据库有两个表的数据量在1千万左右，另外一个在1百万，并不是很大，也做了index，但是不清楚什么原因某些query还是很慢（超过2秒）。 谢谢！ 崔旭
Jie, 我有个mysql数据库，速度需要提高，你有兴趣和时间帮忙吗？ 这个数据库有两个表的数据量在1千万左右，另外一个在1百万，并不是很大，也做了index，但是不清楚什么原因某些query还是很慢（超过2秒）。 谢谢！ 崔旭
...card management system , a need to develop alternatives to achieve full functionality. Features include : And existing interfaces hotel room sales management system ( call each webservice form , with the other engineers do ) ; Membership card classification management , distribution , auditing , enable, payment and other packaging ; Corresponding financial statements , business reports ; Query function ; ( Detailed function menu , see Annex photo ) Claim: We had a similar successful projects ; Autonomously communicate with customers , to explore the details of the demand ; Hotels need to travel to the customer site commissioning and implementation of the ( secondary cities in Sichuan Province ) ; Familiar with business processes better ; Please clearly state y...
Our client has a news website based on Wordpress and it has a mobile adapted plugin already. What we need is an app to be wrote and submitted to the apple store and Android marketplace: Requirements: 1) Submitted successfully and be able to be searched by key words; 2) Be able to push messages to those who has installed the app; 3) Be able to read basic statistics...mobile adapted plugin already. What we need is an app to be wrote and submitted to the apple store and Android marketplace: Requirements: 1) Submitted successfully and be able to be searched by key words; 2) Be able to push messages to those who has installed the app; 3) Be able to read basic statistics for the administrators. The website address is : [dot]com (Pls replace the [doc] with "."...
...charge recharge based procedures, similar to VPNExpress , The implementation of user registration, recharge (Alipay & Paypal), VPN account settings, password changes. The user account, close to expiration reminder, enterprise information submitted invoices, invoice mailing address submitted. The OpenVPN function to read, including account surplus time, monthly bandwidth query, history of bandwidth usage information. The interface is succinct, professional, similar to Bootstrap. We have a billing system Hostbill, so if you can develop Hostbill Api, you can not have the development of Web. 一个OpenVPN收费程序, iOS & Andarid & Website(或者使用Hostbill账单系统) 基于OpenVPN的收费充值程序, 类似VPNExpress , 实现用户注册,充值(Alipay & Paypal),VPN帐号设置,密码变更. 用户帐户, 有接近到期提醒,
We are looking for very well organized & an ambitious self-driven Business Account Manager to join our team (Remote work) <<<<<< Your success measure would be the successful on-boarding of Startup/mid-size organizations every month & min 2 positions to be closed every m...proposition of through proposals and presentations to the prospects. Lead nurturing, engagement, and closing sales. Persuade clients to sign search contracts on an exclusive and/or retainer basis. Provide accurate and detailed forecasts on weekly/ monthly funnel of identified and proposed customers to meet and exceed sales requirements. Email coordination/timely update on whatsapp group by managing query flow of calls/emails/messages from candidate/internal team/clients. Stakeholder ...
I am seeking a Shopify expert who can design and implement an extreme-themed template on our store to selling less than 50 unique backpack products. We bought this theme and we would like you to perform all the tasked needed to set up the theme + 1 demo product so we will be able to start uploading our products this job is to set up the theme only and replace the demo content with images that we will provide and srt up the product pages. - The design needs to be bold and daring, utilising a minimalistic style. - You should have previous experience in designing and setting up successful Shopify stores, particularly with 'extreme' or sports themes. - Excellent content creation skills are required to provide compelling product descriptions and visuals
Crawl, extract, build and publish all Docker Hub, , GitHub, BitBucket, GitLab, Snapcraft, Flatpak, AppImages, DC++, eMule, BitTorrent and SoulSeek as deb packages (APT repository), from ISO, container images, and source code files. Also will run a web server. More details: Is this project for business or personal use? Personal What information should successful freelancers include in their application? Detailed project proposals How soon do you need your project completed? No time limit
As a MongoDB Expert, my primary need is to work with someone who can assist with two key areas: database design and query optimization. Key Responsibilities: - Database Design: I'm looking for assistance in designing the database to ensure it's well-structured and optimized for performance. - Query Optimization: I need an expert who can help in fine-tuning our queries to ensure they're efficient and have minimal impact on our database. Key Skills and Experience: - Proven experience in MongoDB database design and query optimization, especially for small datasets (less than 1 GB). - Solid understanding of indexing strategies and their role in improving query performance. - Ability to communicate effectively and work collaboratively to understand ...
It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.
...Azure Cloud Infra/Azure APIs/Connectors/3rd Party AI Model/AI Tools required for Hosting, Processing, and Training of Models, etc. End Users – Website Users Development Timelines- 30 Working Days. Access: Secure Login Part C: Development and Implementation of Virtual Learning Assistance. • We will provide access to Existing learning Databases (Videos, Books, PDFs). • Bidders must develop API Query to enable Virtual Learning Assistance to Website Users. End Users- Website Users Development Timelines- 30 Working Days. Access: Secure Login AMC Requirement: • The bidder must create, set up, and configure a new cloud infrastructure under the name GCC Law Help and may also require creating and setting up third-party generative Accounts under the name GC...
I have a medium-sized logo that I need in high resolution, urgently, in PNG format. There are no design changes required; just a high-quality redraw to replace the current low-resolution version. Ideal skills and experience for this job include: - Proficient in graphic design tools and software - Proficient in creating high-quality, scalable images - Experienced in logo design and recreation - Able to deliver work with a quick turnaround time
Hi, I am looking for a person to do a data entry job. I will provide a group of 80 files. The job comprises of 3 tasks : For each file: 1. Replace the logo 2. Replace text 3. Create prompt for the text, copy paste from chatgpt Finish!
I have C# MVC Web App that works using SQL Server Database & using APIs at the same time. For the functions that use the database, I want to replace them with the APIs 1- Error message appear with no details, need to make the error message has Show More to display the details of the error. 2- Load Codes from APIs instead of loading from JSON file. (1 API) require updating treeview to load on demand 3- Packages Load from APIs instead of loading from DB (2 APIs) 4- SubscribedPackages Call API instead of inserting into a DB (1 API) 5- Schemes Load from APIs instead of loading from DB (1 API) 6- Uploads Call API instead of inserting into a DB (1 API) 7- Users Call API instead of inserting and reading from a DB (5 APIs) you must have C# MVC experience. ------------------...
...client’s needs. We’re primarily building web-based applications but have opportunities for mobile development as well. You’ll need: In-depth working knowledge of functional React, preferably 16.8+ In-depth knowledge of ES6 syntax Fluent in Typescript Experience using a 3rd party component library (e.g. MaterialUI) and/or CSS frameworks Experience working with state management tools (e.g. React Query) Familiar with Git, including standard development lifecycle (feature branching, pull requests, CI/CD) Experience with React testing methodologies, or a strong desire to write testing An interest in all aspects of the SDLC, including talking to clients is ideal When you work for us, you’ll enjoy: Rapid career advancement based on initiative and performance ...
...robot character I need. Key Requirements: - Create a real looking 3d robot that is 100% unique and original visually appealing, realistic 3D humanoid robot character - Rig the character for full range of motion and flexibility - Design the robot to be able to perform a wide variety of realistic movements including walking, running, and jumping. - I need you to show me how to use Wonder Studio to replace the live person with the 3D character with any blurring around the edges of the 3D character and the character will work realistically, and what plugins would be needed and how to use them. You will show me how to use the software to overlay the 3D Robot character for my videos. - You must be expert using Wonder Dynamics, Wonder Studio. Ideal Skills: - Proficient in 3D modelin...
I'm searching for an experienced website designer and developer to partner with me on an exciting project to replace and rejuvenate a prior website. Important facets of the project will include: - Modernizing the design and layout for a fresh look - Enriching site functionality and features to improve the overall experience I'm specifically looking for individuals who have experience with web design and layout enhancement, as well as implementing new site features. Being able to interpret and incorporate design elements from other websites I admire will be highly suitable for this job. If you believe you can bring innovation, expertise, and creativity to this project, do place a bid. Please be sure to include examples of your relevant work. Looking forward to our collab...
My Laravel project is causing ...performance. Key Responsibilities: - Diagnose the root cause of the performance issue, specifically tied to the high CPU usage - Implement Laravel best practices for handling complex queries - Provide recommendations and implement changes to optimize the project's performance Ideal Skills and Experience: - Proven experience in optimizing Laravel projects - Solid understanding of database indexing and query optimization - Familiarity with caching strategies and how to implement them in a Laravel project This is a high-priority task. Immediate availability and quick turnaround will be highly appreciated. Duevto cpu usage website is not accessible. It require experience. Beginners please do not bid as you will be ignored Server is using cpane...
I am looking for a skilled Photoshop editor who can expertly change my friend's existing attire to a...basketball jersey in a specific picture, as part of a friendly prank. The desired work requires: - Solid Photoshop skills - Strong understanding of lighting and shadows - Detail-oriented adjustments to uphold realism Skills and Experience: - Proven background in Photoshop editing - Previous work involving clothing edits is a plus - Experience in creating realistic photoshop edits You will need to replace the current clothes in the photo with a basketball jersey while maintaining the original lighting and shadows to make the changes appear natural. Your expertise in creating seamless, professional edits will be highly valued in this gig. Please ensure you can deliver this ...
I'm seeking an experienced Google Script specialist to automate tasks and manage data for my project. Here are the specifics: Automating tasks: Your main responsibility will...Script specialist to automate tasks and manage data for my project. Here are the specifics: Automating tasks: Your main responsibility will be to automate data import/export processes using Google Script. I need to take the data attahed to a daily email in excel format, upload this data (and historic) to a data base and then allow to consult that data from different spreadsheet in google with a query. Ideal skills and experience include: - Proficiency in Google Scripts and automation - Experience in data management - Google spreadsheet analisis reports If you have the needed expertise, I'm excit...
Please provide source files for employee ID badge.
...with a clean, minimalist aesthetic. This app should deepen digital relationships through two core functionalities: 1. In-App Messaging: Enable real-time communication among users. Experience in creating intuitive, accessible messaging systems is crucial. 2. Web Conferencing Application Integration: Enable users to jump seamlessly into video calls, mirroring the physical interactions yet to replace. Suitable candidates should have experience integrating external APIs, particularly video conferencing ones. Proficiency in creating a streamlined, user-friendly interface is a must, given this app's minimalist design approach. Creativity in using minimalistic design elements to provide an easy-to-navigate and engaging user experience will be highly valued. Prior experience i...
I am seeking for professional and experienced team to bring my own design to life in my sma...sq. ft.) backyard. The job includes: - Deliver and place imported garden soil, mix with Terracotem. I will buy the products. - Deliver and install new pavement and adjust pit cover level. I will buy paver. - Supply and construct low retaining walls including reinforcing mortar and subsoil line where needed. - Deliver and install composite decking. I will supply composite decking. - Supply and replace side boundary fence. The ideal team will have previous experience in both landscaping and construction, good communication, with a good eye for executing design plans accurately. Please include examples of previous similar works in your bid. Multiple teams / people can apply. I will manage ...
...the objective of this work. I want the Node application to make a connection to MongoDB using the *native Mongo* driver. NOT Mongoose. NodeMon - Project is setup with file monitoring to save development time. Also, the Visual Studio debugger is enabled and appears to be working well. Here is a link to a Visual Studio project which contains a test version of the application error. It has had files removed for security and to reduce the file size. Here’s some rough instructions, I’m not a Node/Docker expert but this should get you going. 1 - Download and uncompressed the Visual Studio zip file 2 - Open the workspace in Visual Studio 3 - Open a new terminal window in the project root folder and run "docker
I have an autocad drawing of a house I need someone to calculate the surface area of the facade for the stone work only excludnig the windows adding to the the exterior part of the boundry wall
...processes it in Wordpress. The Incremental link makes a POST request to this script containing the data. In the script you see 3 types of actions in a switch: Add (new vehicle) Change (vehicle exists, adjustment is being pushed) Delete (vehicle is deleted) Below is a brief explanation of the three functions involved: add_post Here I build a Wordpress Query containing data from the POST request. Then I run a "wp_inset_post" function with this query. From that Wordpress function you will then receive a "post_id" with which I will add photos to the post. change_post Same as "add_post" but I use the "update_post" function because I already know the post_id. Then I'll delete all the photos from this post and add them again. I do ...
I'm in need of a capable graphic designer who can create a logo for my online startup, FlockFindr. I'm looking for someone to make a logo similar to twitter's bird minimal bird logo style. Something friendly, clean, and minimal. #01b8ff should be the hex color. I want something that is ONE Solid Color. I would like text with the logo as well, but the focus should be on the icon. Complicated / complex logos, text-only logos, templates, and logos with multiple colors will be rejected. IMPORTANT: I do not want a logo that resembles Twitter. I want a logo with a similar minimal design style as twitter. Logos that have a bird similar to twitter will be rejected. Please be original.
I'm looking for a professional who can expertly remove backgrounds from 50 product photos. - You will replace the existing backgrounds with a transparent one. - All edited images should be delivered in PNG format. - The retouched images should retain a high-quality resolution, suitable for print quality. Ideal freelancer would be someone with a strong proficiency in using graphic tools and experience in photo editing, especially background removal. Your attention to detail will be critical for this project.
I'm looking for an experienced freelancer to help me configure the folder and file permissions for a specific website on CyberPanel. Key Requirements: - The main goal of this task is to ensure the website's functionality is not hindered by strict security measures. - The website should have specific folders and files with read-only access, and others with read and write access. - Experience working with CyberPanel or similar control panels is essential for this project. In your application, please highlight your relevant experience with similar tasks. Note: Please focus on experience in your application, rather than detailed project proposals. Thanks.
...professional to execute a strategic, monthly SEO plan for my website ( ) aimed at enhancing search engine rankings, increasing web traffic, and accelerating online sales. I have a list of keywords I want my website to rank higher for. Candidate must have knowledge of Keyword/phrase optimization and monitor the progress of each keyword monthly. Offering suggestions to remove or replace any under performing keywords on a monthly basis. The target demographic for website visitors - (Gender: Female; Age: 20-40; Country: USA). The candidate should be familiar with core SEO practices, including: - Keyword/phrase optimization - On-page SEO tactics - High-quality backlink generation - Site performance improvement - Google analytics - MOZ and DA Rank Improvement Ideally, the right
I am seeking a skilled photo editor or graphic designer to modify an existing image. Key Tasks: - Replace one person in the image - The replacement should incorporate a specific humorous element - detailing a man with the phallic part in the mouth of another man Although the client has not specified gender, age, or appearance for the replacement person, the ability to incorporate the described element with care and creativity is crucial. A background in caricature or cartoon-style graphics may be advantageous. Ideal candidate: - Proficient in Photoshop or similar - Experience in photo retouching and manipulation - Ability to work with humor and sensitivity - Expert in blending elements naturally Your proposal should include similar image alteration projects you have compl...
I have a large volume of numerical data that needs to be entered from multiple digital files. The files will be provided to you in a digital format. Key Requirements: - Data Entry: Accurately input numerical data from digital files into a specified format. - Efficiency: Handle a substantial quantity of data in a timely manner. Ideal Freelancer: - Proficient in data entry with experience in handling numerical data. - Attention to detail to ensure accuracy. - Previous experience with large-scale data entry projects is a plus.
...JavaScript framework (React, Angular, Vue.js) considering factors like project complexity, team expertise, and desired features. Back-end: Select a server-side technology (Node.js, Python with Django/Flask, PHP with Laravel) based on performance requirements, scalability needs, and developer familiarity. Database: Choose a suitable database (MySQL, PostgreSQL, MongoDB) based on data structure, query complexity, and scalability requirements. Other Considerations: Authentication/authorization, payment processing (if applicable), CMS (if needed). 3. Development Process: Front-end Development: Implement the user interface and user experience using your chosen framework, following component-based architecture for maintainability. Back-end Development: Build your server-side APIs usin...
I have a large volume of numerical data that needs to be entered from multiple digital files. The files will be provided to you in a digital format. Key Requirements: - Data Entry: Accurately input numerical data from digital files into a specified format. - Efficiency: Handle a substantial quantity of data in a timely manner. Ideal Freelancer: - Proficient in data entry with experience in handling numerical data. - Attention to detail to ensure accuracy. - Previous experience with large-scale data entry projects is a plus.
It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.
I need a skilled Photoshop professional to edit the background of my photos. Specifically, I need: - Object Removal: Please remove brick background and replace with blurred pretty greenery from the photos seamlessly, ensuring the final images look natural and unaltered. Back of her white sweater on the left side is bumpy and needs to be removed - Moderate Retouching: Apply moderate retouching, focusing on skin smoothing and blemish removal. Especially the little girls bruised knees and the faint bruise on her forehead. The goal is to enhance the overall quality of the images without making them appear unnatural. The edited photos must be ready for printing, so please ensure they are of high quality and suitable for this purpose. Ideal skills & experience: - Proficiency in P...
I need a skilled Photoshop professional to edit the background of my photos. Specifically, I need: - Object Removal: Please remove brick background and replace with blurred pretty greenery from the photos seamlessly, ensuring the final images look natural and unaltered. Back of her white sweater on the left side is bumpy and needs to be removed - Moderate Retouching: Apply moderate retouching, focusing on skin smoothing and blemish removal. Especially the little girls bruised knees and the faint bruise on her forehead. The goal is to enhance the overall quality of the images without making them appear unnatural. The edited photos must be ready for printing, so please ensure they are of high quality and suitable for this purpose. Ideal skills & experience: - Proficiency in P...
I'm looking for a proficient SQL professional with notable expertise in SQL Server 2019. Key tasks will involve: - Query optimization - Database design - Data migration The ideal candidate should have a solid understanding of SQL Server tools and a proven track record in handling similar projects. Your previous experience and knowledge of SQL Server 2019 will be pivotal in this role. Your task will be primarily centered around maximizing the efficiency and effectiveness of the SQL Server. Preference will be given to professionals with certifications in SQL Server 2019 or related fields. Solid written and verbal communication skills are desirable.
I have an issue with my Dell laptop's hardware component – the fan isn't working properly. Unfortunately, I lack the knowledge to fix this problem myself, ...Unfortunately, I lack the knowledge to fix this problem myself, so I'd love to hire a freelancer who is well-versed in Dell laptop hardware repair. Ideal Skills Needed: • Extensive knowledge in fixing Dell laptops, specifically fan repairs. • Good troubleshooting skills to determine if any other issues are contributing to the problem. What to Expect: • Analyze the Dell laptop's fan. • Repair or replace the faulty fan. • Ensure my laptop is functioning properly post-repair. Please only bid on this project if you have a proven background in this specific field. This is an ur...
I'm in search of a meticulous data entry specialist to help with a simple text data entry task. The job is quite straightforward, involving the transfer of information from digital files to a different format. The role strictly involves data entry without the need for any form of data analysis. Key responsibilities: - Accurately entering text data from digital files into a specified format. Ideal Skills and Experience: - Proven experience with data entry. - Attention to detail. - Proficiency in working with digital files and transferring data.
I need someone to upload files of a website on my namecheap hosting. I have .zip file with full website files (wp-content, wp-config and all the others) and I need this to be uploaded and made to work on my namecheap hosting and database.
As an exper...experience in Laravel and you're familiar with Laravel 11. • You've previously developed websites using Laravel 11. • Your forte is optimizing code efficiency and database queries. • You have a strong understanding of how to improve page load times and database query speed. Your task: • Optimize my existing codes in Laravel 11, for open source project • Main areas for optimization include database queries and code efficiency • The goal is to achieve faster page load times and improved database query speed. • Test subscription and plans, if it works fine or not Please, only apply if you have the mentioned skills and experience and you're able to demonstrate evidence of past projects you've optimized for p...
I am in need of an exp...developer to create an interactive, transactional platform with the ability for information sharing, social interaction, and query resolution. This platform should be accessible both as a mobile app and a website, with seamless functionality across Android, iOS, and various web browsers. The ideal candidate for this job would have the following skills and experience: - Expertise in both app and web development, with a portfolio of interactive, transactional sites/apps. - Experience with Android & iOS app development. - Understanding of user experience, particularly in relation to e-commerce and social networking. - Proven problem-solving skills in the area of query resolution. Please provide examples of your work and detail your experience w...
I'm looking for a skilled developer to create an efficient FTP script that will allow me to upload files to a specific folder in cPanel. Key Requirements: - The script should be optimized for small files, as large file handling is not a priority. - It should be developed in a language suitable for FTP functionality. The script will be used to automate the process of uploading files to a specific folder on a cPanel server. The ideal developer should have experience in: - Building FTP scripts for file uploads - Working with cPanel and its file management system - Ensuring the script runs smoothly for smaller files Please include in your proposal your experience with similar projects and any relevant skills that make you the ideal candidate for this task.
It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.
I have a photo that needs some professional touch-urgently. i need this back within 1 hour - 2 hours Key Requirements: - Change Background: I'm looking to replace the existing background with a smooth and uniform solid white. - Remove Shadows: I need all shadows removed to ensure the subject stands out clearly. - Adjust Position: The person in the photo currently needs a slight adjustment to their pose. Ideal Skills: - Proficiency in Photoshop: A strong understanding of Photoshop is essential to make these changes seamlessly. - Photo Editing Experience: Experience in editing photos to create a uniform look and feel. - Attention to Detail: The project requires a keen eye for detail to ensure a professional finish. The person I'm looking to hire should be able to comple...
UPDATE GATEKEEPER BOOK COVER with revised author bio and new author photo to replace the STAR logo. Thank you.
I need a skilled photo editor to transform a family portrait into a fun and interesting images. Here's what I'm looking for: Either (not all in one photo) - Replace the boy in the picture with a girl and baby Yoda. - Replace dad with Dwayne Johnson. - Replace mom with an alien. addiotionally, - Add a great background like cartoon themed funny or anything to make it impressive The ideal freelancer for this job should be experienced in img2img editing and manipulation in Stable Diffusion. Understanding of humor and creativity is a plus. Blend the image so it looks realistic even with edits. Most importantly, I will need to the model names used and the seed for pictures to take it up from there and edit further. Multiple sumbimissions per person are okay. T...
use submitted requirements and add to the existing figma protpotype. the job needs to be done rapidly
