In Progress

Optimize SQL query in OSCommerce

Our oscommerce shop (MS2 RC2 version) have a sql query issue.

Please visit the test store here:

[url removed, login to view]

The following issue exists in the header menu, for product categories, e.g.

[url removed, login to view]

[url removed, login to view]

In the buttom of the page you can see the load time for the page, which is WAY to slow.

This problem exists with all menu links using the cPath variable.


In the oscommerce store, we have the SEO-G contribution installed, however this is currently disabled, since the load time was even slower when enabled. We suspect the SEO-G contribution is also affected by the slow load time, and somehow is connected.

If you instead try to use our search by price/size menu in the left column, you will see the load time drastically reduced.


[url removed, login to view]

We want the same fast performance in our header menu.

We believe that the issue is located in the [url removed, login to view] file with some specific queries in here.

Please PM us before you place your bid with the following:

- What in your opinion is an acceptable load time for the header menu, based on your first glance of the oscommerce store and your knowledge of oscommerce in general.

- Please consider the aspect of SEO-G and how it may be involved in the issue of slow load time.

- Your assesment of the task (how you will proceed if chosen, and time frame)

- if required, we can send you the index file through PM.

The chosen provider will have FTP and phpmyadmin access for the test site, and must provide full documentation of file changes, database changes and updates, so that we can implement the fixes ourself on the live site.

Best regards


Skills: OSCommerce, SQL

See more: oscommerce seo slow, oscommerce search sql, oscommerce site queries, seo cpath, sql query oscommerce, optimize sql oscommerce, slow sql query oscommerce, sql price, problem categories, n query, fast shop, seo slow, oscommerce search sql slow, optimize oscommerce sql queries, seo database changes, optimize oscommerce, optimize query oscommerce, oscommerce cpath slow, search query oscommerce, seo slow load time oscommerce, oscommerce sql, optimize oscommerce database, md n, sql, SQL Query

About the Employer:
( 22 reviews ) Copenhagen, Denmark

Project ID: #598801

Awarded to:


Hi, We can help you. Best Regards,

$30 USD in 2 days
(334 Reviews)

5 freelancers are bidding on average $44 for this job


Hi, I can see "Time taken = 7.28 secs". I think it is slow SQL or wrong index(es) on table(s). I can speed up liknks like [url removed, login to view] in one day. I need FTP access and phpMyAdmi More

$50 USD in 1 day
(182 Reviews)

Hi, view pmb for details, thanks.

$31 USD in 1 day
(17 Reviews)

can be done within 5 hours !

$65 USD in 1 day
(1 Review)

I am having a 6+ years of experience in database with OCP and performance tuning and deals with varios online systems. regarding yor query - What in your opinion is an acceptable load time for the header menu, bas More

$45 USD in 3 days
(0 Reviews)