Cancelado

Make my MySQL / PHP search script fly, have tried full text index but didn't work

I need my MySQL queries to work much faster, they take around 0.4 second each. Heres my current queries $SQL = "select padid from pads WHERE (keywords like '%$search%' or ProgramName like '%$search%' or English45 like '%$search%') AND RemovemeDate = '2001-01-01 00:00:00' ORDER BY VersionAddDate DESC"; $SQL2 = "select * from pads LEFT JOIN categories ON [url removed, login to view] = [url removed, login to view] WHERE (keywords like '%$search%' or ProgramName like '%$search%' or English45 like '%$search%') AND RemovemeDate = '2001-01-01 00:00:00' ORDER BY VersionAddDate DESC limit $offset,20"; I will give you the full amount of records that I use at the moment for the relevant tables. However, I can't give you all the fields, just the relevant ones. This SHOULD be enough to give you an accurate representation of my database. I have also included my full script file for reference purposes, the output of the script should remain the same. To make things easier I have included a cut down script which just show the data. I've tried creating some indexes but I can't get these to work. I don't want to have to create new tables. I am willing to provide the data during the bidding process. PLEASE NOTE: You should use the keywords table instead of the [url removed, login to view] field. This will be obvious when you see the data. Acceptance will be made once I have run the queries on the live server and the queries run a lot faster than now. Ideally, the query times should be [url removed, login to view] or less.

## Deliverables

1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement).

## Platform

MySQL, Windows Server

Habilidades: MySQL, PHP

Ver mais: worker search, search worker, php catid, make order site, hire script, creating php table, mysql php, mysql index, php mysql join table, mysql join table, mysql table join, tried, create script windows, mysql search table, sql create script, mysql select platform, search categories, order query platform, mysql create table data, legal representation, mysql search database table, mysql create table fields, worker php, sql select order, mysql output table

Acerca do Empregador:
( 103 comentários ) Consett, United Kingdom

ID do Projeto: #2995901

4 freelancers estão ofertando em média $34 para este trabalho

brainwithstorm

See private message.

$34 USD in 3 dias
(27 Comentários)
4.8
spx2vw

See private message.

$34 USD in 3 dias
(36 Comentários)
4.7
nightspeed

See private message.

$34 USD in 3 dias
(1 Comentário)
0.5
zees2012

See private message.

$34 USD in 3 dias
(0 Comentários)
0.0