Em Andamento

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.

Notice:

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.

e.g.

[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

MD-Import

Habilidades: OSCommerce, SQL

Ver mais: 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

Acerca do Empregador:
( 22 comentários ) Copenhagen, Denmark

ID do Projeto: #598801

Premiar a:

SunrisePHP

Hi, We can help you. Best Regards,

$30 USD em 2 dias
(334 Avaliações)
6.8

5 freelancers estão ofertando em média $44 para este trabalho

TakeReal

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 Mais

$50 USD em 1 dia
(182 Comentários)
5.7
ARNLWEB

Hi, view pmb for details, thanks.

$31 USD em 1 dia
(17 Comentários)
4.3
VeryFastSolution

can be done within 5 hours !

$65 USD em 1 dia
(1 Comentário)
0.0
tovipulvaja

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 Mais

$45 USD in 3 dias
(0 Comentários)
0.0