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.
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).
MySQL, Windows Server