VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: metmusic on March 18, 2015, 12:30:57 PM

Title: Too much database queries while loading products or limit to low?
Post by: metmusic on March 18, 2015, 12:30:57 PM
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!
Title: Re: Too much database queries while loading products or limit to low?
Post by: Studio 42 on March 18, 2015, 15:41:34 PM
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, ...