Prestashop 1.4.0.17 performance

[jaimemm]

Hi,

I have a clean Prestashop 1.4.0.17 installation, with memcached set up in a Ubuntu dedicated server (2GB RAM and dualcore 1GHz processor). MySQL 5.1.14 with query cache enabled.

The database contains 8 categories with 3 subcategories each (24 in total). And only 3 products in total, so the database is quite light in terms of products.

Using loadUI (www.loadui.org), I've set up a 3 step load test:

- Index
- Category 1
- Cart

At 1 request/second rate, the results are awful: response time 8sec and increasing with every request (no limit)

Of course with a better server will have better response time, but what is not acceptable is the response time to be increasing.

The bottle neck is the Cart task, which makes important access to the database. The other 2 tasks (INdex and Category1) are resolved by cache.

Did anyone tried a load test with prestashop? Could you please share your results?

Does anyone how to speed up the DB access?

Cheers

[jaimemm]

Update:

Even with 1 single step i.e the index, over 1 request per second the response time increases in an unacceptable way.