News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

Too much database queries while loading products or limit to low?

Started by metmusic, March 18, 2015, 12:30:57 PM

Previous topic - Next topic

metmusic

Hello,

What is typical amount of database queries while loading category page containing i.e. 20 products? For me this number is ca. 200. My hosting company has limited database queries to 50k so way to achive this amount is short... Then they are blocking db user and I'm getting "Database connection error (3): Could not connect to database" error instead of page.

Example server log lines:
140826 10:35:42 [Warning] Aborted connection 3693263 to db: 'unconnected' user: XXXXX' host: 'localhost' (init_connect command failed)
140826 10:35:42 [Warning] User 'mdesopl_madrona' has exceeded the 'max_questions' resource (current value: 50000)
140826 10:36:17 [Warning] Aborted connection 3693441 to db: 'unconnected' user: 'XXXXX' host: 'localhost' (init_connect command failed)
140826 10:36:17 [Warning] User 'mdesopl_madrona' has exceeded the 'max_questions' resource (current value: 50000)

What shoud I do? Is 50k limit not to low?
Thanks for help in advance!

Studio 42

hi,
DO not use a provider that limit sql queries in a shop. Virtuemart or not.
Or you an loose some shoppers action, writing the order, adding payment in table, ...