I have a simple script written in php/mysql. The problem is that at the moment the mysql querys inside the script require to much system resources so i want them optimized, or whatever to make it run faster/more efficient.
Basically what the script does is compare 1 table with another table to find string matches. Those matched strings are shown on the screen grouped by name.
Table1 has like 10k records and there will be 50k new records added every month.
Table2 has like 20k records and gets updated with 2400 new records every day.
The mysql query compares a table1 word string with all records inside table2 to find a match. It does that for every single record. So imagine with 20k records in both tables mysql must go through (20k x 20k)= 400million records to find the results i want.
I want a mysql expert that has ideas on how to improve the table structure/mysql query's so that the query time get ALOT lower. the optimized script must be able to do exactly the same, only faster. I dont care if you need to make changes to the script/table structure.
My budget is low, 50USD only. If you are mysql expert and wanna try to help me out with this or wanna expand your portfolio. Give it a try.
Thanks in advance,
35 freelancers are bidding on average $46 for this job
Hi, I am a database application programmer with more that 10 years experience. I can do this job for you. Please view my PMB for details, Thanks and best regards, Paul