Dibatalkan

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.

Kemahiran: Pemprosesan Data, Perl, PHP

Lihat lebih lanjut: 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, Mysql expert, mysql 4, find php expert, expert system, mysql structure

Tentang Majikan:
( 54 ulasan ) Uithoorn, Netherlands

ID Projek: #367864

35 pekerja bebas membida secara purata $46 untuk pekerjaan ini

VALUEONWEB

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

$50 USD dalam 0 hari
(212 Ulasan)
7.9
NickolaS

Hi, please, check your PM

$50 USD dalam 0 hari
(334 Ulasan)
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 Lagi

$50 USD dalam sehari
(162 Ulasan)
7.4
soniamit

let starts....... regards soNiamit

$50 USD dalam sehari
(156 Ulasan)
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 dalam 0 hari
(74 Ulasan)
6.2
zub

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

$50 USD dalam 2 hari
(61 Ulasan)
6.0
Pektsekye

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

$50 USD dalam 2 hari
(107 Ulasan)
5.6
parambnb

hi please check pmb

$50 USD dalam 0 hari
(16 Ulasan)
5.7
fedmich

Hi, MySQL expert here. Pls check PM

$50 USD dalam 0 hari
(50 Ulasan)
5.3
crajeshbe

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

$30 USD dalam 0 hari
(37 Ulasan)
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 dalam 0 hari
(2 Ulasan)
4.9
frankouz

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

$45 USD dalam 2 hari
(11 Ulasan)
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 dalam sehari
(7 Ulasan)
4.7
shevkorn

Let me help you in this project.

$50 USD dalam 7 hari
(15 Ulasan)
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 Lagi

$50 USD dalam 20 hari
(2 Ulasan)
4.0
KJPHPDev

Please check your PM

$50 USD dalam 2 hari
(7 Ulasan)
3.5
fabioce

Hi, give more info about your job

$50 USD dalam sehari
(2 Ulasan)
3.4
srilankaservices

Please check the PMB

$50 USD dalam sehari
(1 Ulasan)
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 Lagi

$40 USD dalam 2 hari
(1 Ulasan)
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 dalam 5 hari
(1 Ulasan)
0.8