MySQL Optimization for Oscommerce.

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]

Taidot: PHP, SQL

Näytä lisää: oscommerce mysql optimization, mysql optimization oscommerce, mysql log oscommerce, mysql data files, sql mysql, php mysql sql example, rewrite sql, mysql tables rows, joins, rewrite data php mysql, mysql log, mysql budget, php mysql rewrite, mysql queries using, sql php oscommerce, hour budget, mysql data tables, rewrite php mysql, optimization oscommerce queries, optimization sql oscommerce, mysql left, oscommerce queries, data oscommerce, files oscommerce, use oscommerce

Tietoa työnantajasta:
( 15 arvostelua ) Delray Beach, United States

Projektin tunnus: #485577

1 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_23% %project_currencyDetails_sign_sub_24% tähän työhön


I am interested

$30 USD 1 päivässä
(39 arvostelua)