I have some queries that are not properly using indexes on the Tables.
I want to provide you the queries and have them rewritten to use proper indexes on the tables.
Most of them are using improper Left Joins.
Some of the queries are scanning a 100K rows of data to find one result.
Please - Only those with Oscommerce experience and MySQL knowledge bid
For someone experienced this should take a matter of an hour to rewrite the queries.
I can provide an example and log files via PM if needed to see what i am referring to.
Budget is around [url removed, login to view]