Find Jobs
Hire Freelancers

Optimizing PHP code and data structure for mySQL to speed up queries

$30-250 USD

Ukończony
Opublikowano około 7 lat temu

$30-250 USD

Płatne przy odbiorze
Rules for this project! 1. All bids that doesn’t involve the word ”Carrot” will be ignored 2. Only bid if you have the knowledge and expertice to successfully finnish this project in time. If you dont understand the project as described then dont bid. 3. Only bid the amount that you are willing to do the project for. 4. You MUST deliever the project on time (14 days from accepted bid) or else no payment. 5. The project is finnished when uploaded to my server and quality checked by me. Project description: I have a mySQL database that is around 880 mb in size. It is in one database with 6 tables of data. Every table has around 2,9 million rows of data. The queries is fetched by an PHP application (varnish PHP). The application return around 5000 rows of data to the user in the users query. The data in the database is data from 290 municipalities with the following data for each municipality: population, population growth, inmigration, outmigration, death, born. The fetch time is around 60-70 seconds when making queries from the PHP application. I like the fetch time to be under 5 seconds for a search. You could suggest and do the follwing to speed up the queries: Optimizing/ change the PHP code Structure the mySQL data differently in multiply databases or adding more tables. Database structure: 1 mySQL database 6 tables with data 7 column i every table 2,9 million rows data in every table Webhost server: Shared webhost server at [login to view URL] 500 GB storage 4 GB RAM Multiple databases 8 x CPU
Identyfikator projektu: 13313970

Informację o projekcie

27 ofert
Zdalny projekt
Aktywny 7 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
Przyznano:
Awatar Użytkownika
Carrot I have quite a lot expertise in SQL and have helped serveral people to speed up their databases and queries. Often the problem is not in the PHP-Code, which is also possible, but mostly it is located in the structure because primary keys, relations or similar approaches has not been taken advantage from.
$111 USD w 2 dni
5,0 (2 opinii)
2,3
2,3
27 freelancerzy składają oferty o średniej wysokości $179 USD dla tej pracy
Awatar Użytkownika
Dear, I am Smile Song, Mobile developer in China. I've just read your job posting and I’m very interested. I'm a certificated freelancer with almost 600 good reviews from clients. I have experienced knowledge in every part of mobile technology. I know how to bring your idea alive and communication well. I never disappoint my clients and I’m able to lead your project to success and troubleshoot problems. I am sure these will reflect in my past results. Please contact me if I am a match for you are looking for. Best Regards, Song
$257 USD w 7 dni
4,9 (847 opinii)
9,3
9,3
Awatar Użytkownika
Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks
$195 USD w 7 dni
4,8 (472 opinii)
8,3
8,3
Awatar Użytkownika
Carrot hi I have read the project description, i can optimize it by restructuring database and adding more tables to make it easy for query to fetch data quickly. Please discuss further. thanks tamoor
$250 USD w 14 dni
5,0 (137 opinii)
7,5
7,5
Awatar Użytkownika
Thank you for the invitation! First of all I know about ”Carrot”! I'm sure I can optimize your code/database but I need to know a bit more information. Can you show me your database schema and your SQL search query? Also I need to know is 60-70 seconds a time of the query or this is a time the user get whole result? Thanks. Roman
$88 USD w 2 dni
5,0 (516 opinii)
7,6
7,6
Awatar Użytkownika
Carrot Hello, After reading your project details I believe I'm suitable for this PHP & SQL project. As I'm expert on PHP & SQL with more than 5 years experience. Please feel free to contact me. I am looking forward to hear from you. Best regards
$250 USD w 7 dni
4,9 (136 opinii)
6,8
6,8
Awatar Użytkownika
Hello, I have gone through your outsourced requirements "Optimizing PHP code and data structure for mySQL to speed up queries " and have analyzed that I have right skills (Database Development, Database Programming, MySQL, PHP, Software Architecture) to execute your esteemed project. I will complete your project within 3 days, LIFETIME error free guarantee and provide 365 days (ONE YEAR) support... ===== Why choose me? ===== 5.0 / 5.0 rating, 100% completion rate, 100% on-time completion, 100% on-budget :) Kindly, check my profile: http://www.freelancer.com/u/BitLabs.html I work smart, hard, and strictly bid only what we can do! No sub-contracting... ever! You will never go wrong choosing me :)
$175 USD w 3 dni
5,0 (115 opinii)
6,7
6,7
Awatar Użytkownika
I love carrots... Or ... Mysql... :) Hi ! I think you might Have found your freelancer, but if not, I am willing to help. To summup, you have a database with 2.9millions rows, 880Mb which is slow where querying from PHP. The target is 5 seconds... Questions : - how many "filters" are applied on the query ? - how "dynamics" is the content ?I mean, it's a static dabase (no update) or, in constant growth ? - can you provide table schema ? - can you provide sample queries ? - did you checked table's indexes ? thank you in advance, and drop me line if you need my help. Rudy / Frenchlancer.
$200 USD w 14 dni
5,0 (25 opinii)
6,9
6,9
Awatar Użytkownika
Carrot Hi there. I have read all the terms you listed and can work according to them. I have extensive experience in optimizing servers, web apps, clusters, and databases. Let's discuss!
$155 USD w 3 dni
4,9 (84 opinii)
6,3
6,3
Awatar Użytkownika
Carrot Hi, I can help to optimize the query performance. Please could you send me the queries you use in your php application so that I can take a look and see the timing and tune them please Thanks Shaji
$100 USD w 7 dni
5,0 (125 opinii)
6,0
6,0
Awatar Użytkownika
Carrot Hi I can make this optimization for You, i need copy of database and php script. Please contact me to talk about details.
$166 USD w 14 dni
4,9 (58 opinii)
5,6
5,6
Awatar Użytkownika
Carrot,Carrot,Carrot,Carrot,Carrot Hi, I've read and understand your requirements and I can work in optimizing speed and code structure.
$166 USD w 10 dni
4,9 (56 opinii)
5,5
5,5
Awatar Użytkownika
Carrot. Hi do you use myISAM engine in your tables? .
$222 USD w 14 dni
5,0 (31 opinii)
5,4
5,4
Awatar Użytkownika
Carrot !!! Hi, I'm a DB expert from Bulgaria, with solid background in MySQL and many other RDBMS. I'm not a PHP guru, but If you think the problem comes from the DB, I definitely can help you here. Best Regards
$250 USD w 14 dni
5,0 (4 opinii)
4,4
4,4
Awatar Użytkownika
Hi, #involve i am a software developer with strong experience in php, mysql i have read your project description and i think we can do an amazing work together. returning 5000 rows is not a big problem if your data base schema designed well if you intersted on my offre , i will check it for and optimize it by adding indexes and or split table or using view to improve mysql performance queries . looking forward to hearing from you. best regards.
$111 USD w 14 dni
5,0 (1 opinia)
2,9
2,9
Awatar Użytkownika
'carrot' . i am expert in pho and mysql. i am interested in this opportunity. please open a chat window to discuss more about the project.
$166 USD w 5 dni
5,0 (6 opinii)
2,8
2,8
Awatar Użytkownika
I have 15+ years experience in database design and implementation, using everything from Excel to Access to MySQL, often as a back end to web-based platform implementations. Some data sets have been in excess of 4 million records, and so I have some experience optimizing and devising efficient database structures. A part of the problem may be indexing; a part may be the data structure design; a part may be the queries themselves; and a part may well be server configuration. All of these elements will need to be considered. Incidentally, Carrots are good for your eyes. Eat them. (I have been away from the freelance world for a number of years and so am working on re-establishing myself here, hence the lower bid amount.)
$55 USD w 10 dni
5,0 (5 opinii)
2,3
2,3
Awatar Użytkownika
I'm not fond of carrots. However your problem should easily be solved. As long as access to the server in question is granted It should not be difficult to find where your problem lies and tweak the system as needed. That may involve indexes or restructuring the data and queries to be as efficient as possible.
$166 USD w 3 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
Carrot I am eager to bring following qualifications to your organization: • Demonstrated ability to meet with clients and build/document web site requirements • Effectively able to plan mock-ups and storyboards • Adapt at optimizing content by means of various SEO techniques • Track record of creating website architecture and finding out hardware and software requirements • Knowledge of choosing and arranging information
$155 USD w 3 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
A proposal has not yet been provided
$200 USD w 10 dni
0,0 (0 opinii)
0,0
0,0

O kliencie

Flaga SWEDEN
Gällivare, Sweden
5,0
36
Zweryfikowana metoda płatności
Członek od mar 26, 2011

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.