Cancelled

Mysql Expert needed

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,

Koenders.

Skills: Data Processing, Perl, PHP

See more: word portfolio, the string problem, string problem, string match, string find c, single match, match string, match problem, i need a php expert's help, how to get cgi, find a expert, sitewwwgetafreelancercomprojects koenders, koenders, project creator koenders, est time mysql query examples, word xml, mysql expert freelancer, improve table structuremysql query query time alot lower, php charts, mysql query

About the Employer:
( 54 reviews ) Uithoorn, Netherlands

Project ID: #367864

35 freelancers are bidding on average $46 for this job

VALUEONWEB

We are expert in MySQL We are ready to start this project

$50 USD in 0 days
(212 Reviews)
7.9
NickolaS

Hi, please, check your PM

$50 USD in 0 days
(334 Reviews)
7.5
codersam

We are absolutely suitable for this project as we have already done the different type(Social Community/Networking/Dating, Mambo, Joomla, Oscommerce, Zencart, Real Estate, Ecommerce/Auction, Video Related, General an More

$50 USD in 1 day
(162 Reviews)
7.4
soniamit

let starts....... regards soNiamit

$50 USD in 1 day
(156 Reviews)
6.4
RRStoyanov

I have script which works pretty fast with two tables (one with ~100k, and another with more than 300k rows).

$44 USD in 0 days
(74 Reviews)
6.2
zub

Hello Sir, Please see the Pm. thank you. With regards zub

$50 USD in 2 days
(61 Reviews)
6.0
Pektsekye

can you attach the script and mysql dump of both tables to try ?

$50 USD in 2 days
(107 Reviews)
5.6
parambnb

hi please check pmb

$50 USD in 0 days
(16 Reviews)
5.7
fedmich

Hi, MySQL expert here. Pls check PM

$50 USD in 0 days
(50 Reviews)
5.3
crajeshbe

Can you provide me your db backup ... Regards [login to view URL] B.E

$30 USD in 0 days
(37 Reviews)
5.3
GotiSoft

Dear Sir, I have carefully read your requirements and I am sure I can help you with your problem. For more informations please check PM.

$45 USD in 0 days
(2 Reviews)
4.9
frankouz

I can do it. Let me know the table structure. View PM for details

$45 USD in 2 days
(11 Reviews)
5.0
CoderTech

I do have to see the queries you refer to before I can tell you if they can be improved. Thanks.

$50 USD in 1 day
(7 Reviews)
4.7
shevkorn

Let me help you in this project.

$50 USD in 7 days
(15 Reviews)
3.9
cnut17

that's simply the wrong way to do that. on huge databases, all queries including the LIKE operator or any word search should be banned. The right way is to have more tables and indexes that allow to find the right info More

$50 USD in 20 days
(2 Reviews)
4.0
KJPHPDev

Please check your PM

$50 USD in 2 days
(7 Reviews)
3.5
fabioce

Hi, give more info about your job

$50 USD in 1 day
(2 Reviews)
3.4
srilankaservices

Please check the PMB

$50 USD in 1 day
(1 Review)
2.7
suryavikas

Hi I am a software engineer working for a very reputed company of US. My Primary responsibility is this organization is Db administration and Automation. I take care of all query tuning and report automation requirem More

$40 USD in 2 days
(1 Review)
1.6
pulsar996

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

$50 USD in 5 days
(1 Review)
0.8