Sedang Disiapkan

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


Kemahiran: OSCommerce, SQL

Lihat lagi: 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

Tentang Majikan:
( 22 ulasan ) Copenhagen, Denmark

ID Projek: #598801

Dianugerahkan kepada:


Hi, We can help you. Best Regards,

$30 USD dalam 2 hari
(334 Ulasan)

5 pekerja bebas membida secara purata $44 untuk pekerjaan ini


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 [login to view URL] in one day. I need FTP access and phpMyAdmi Lagi

$50 USD dalam sehari
(182 Ulasan)

Hi, view pmb for details, thanks.

$31 USD dalam sehari
(17 Ulasan)

can be done within 5 hours !

$65 USD dalam sehari
(1 Ulasan)

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 Lagi

$45 USD dalam 3 hari
(0 Ulasan)