solve slow OScommerce shop-problem - MySQL

OScommerce shop



transition [url removed, login to view] to [url removed, login to view] is slow (1 minute)


altering the status of an order takes very long (1 minute) , but if you open another browser window, the order-status is already changed


adding a new customer takes very long (1 minute), but if you check in the admin it has been added to the database within seconds


There is a phpBB-board on the same dedicated server server, that also has the same problem: if you add a message, it (sometimes) takes a long time to show, but if you open another browser window it is already there.


The shop runs on a dedicated server that has virtually no load:

OS: Linux 2.6.11-1.1369_FC4smp

Server Up Time: 06:31:09 up 107 days, 19:33, 0 users, load average: 0.00, 0.00, 0.00

Database: MySQL [url removed, login to view]

HTTP Server: Apache/[url removed, login to view] (Fedora)

PHP Version: 5.0.4 (Zend: 2.0.4-dev)

I suspect this is a MySQL-problem or some poor programming of contributions, so I am looking for an expert in MySQL, PHP and OScommerce.

Taidot: eCommerce, Linux, PHP

Näytä lisää: oscommerce slow mysql, php programming problems, mysql php programming, c# database mysql, apache programming, 1. problem, 1 problem, so slow, mysql 5.1, expert window, zend expert, solve some, solve problem, shop, problem, php solve, mysql 4, load board, fedora, average php mysql, load average, check order status, zend time, linux apache programming, phpbb mysql

Tietoa työnantajasta:
( 15 arvostelua ) Roosendaal, Netherlands

Projektin tunnus: #514448

10 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


I developed a few oscommerce websites so far. I cannot tell you the time need or the problem until i have more details. Might be some unset indexes... Message me if you want to know more information Thank you

$500 USD 1 päivässä
(32 arvostelua)

Hi, I am a Experienced Linux/DBA and Webserver administrator, PHP developer, currently handling 500+ linux servers, with great design network infrastructure. Managing 70 high end Mysql Database Server, tunned for best Lisää

$383 USD 4 päivässä
(10 arvostelua)

we can help you fix it.

$250 USD 4 päivässä
(1 arvostelu)

Hello pls see pm

$300 USD 3 päivässä
(3 arvostelua)

i can do this work.i will work with dedication still you get satisfied 200%. see PMB

$260 USD 5 päivässä
(1 arvostelu)

I solved this problem yearly, and can do it again. We have to optimize sql-queries and update some code.

$400 USD 5 päivässä
(0 arvostelua)

Hello. The information you have provided us, can help us set up and resolve this issue for you. We are native English Speakers, with heavy Linux and *nix experince, along with MySQL, and can correct this for you so tha Lisää

$250 USD 5 päivässä
(1 arvostelu)

I can optimise your SQL queries as an expert in MySQL, PHP and OScommerce. See PM

$250 USD 5 päivässä
(0 arvostelua)

Hello. I'm an expert in Linux networking/Apache/MySQL. It seems you have networking/web scalability problems rather than MySQL slowness. I can help you to figure out the reason and to fix.

$300 USD 3 päivässä
(0 arvostelua)

Hello, I have been working on php more than four years and working on OsCommerce from last two years. would like to get a chance to serve your problem. Will look forward to your response. Thanks! Komal

$400 USD 5 päivässä
(0 arvostelua)