VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: leighjam on February 21, 2014, 22:15:50 PM

Title: Shopper Administration Filter Selection Pegs CPU
Post by: leighjam on February 21, 2014, 22:15:50 PM
When on the shoppers administration page if the filter dropdown is moved from  "only joomla" to all. Any filter request will hang the server.  Specifically MySQL attempts to pull such a large data set that it hangs the server (on a 6 CPU system it was at CPU 300%)  After restarting Apache and MySQL everything returned to normal. 

Is there a purpose for this option or can it be disabled as an 'accident' can cause serious problems?

Thanks!

Joomla 2.5.9
VirtueMart Version 2.0.22b
Title: Re: Shopper Administration Filter Selection Pegs CPU
Post by: Milbo on February 24, 2014, 00:09:42 AM
That is the reason we have the option. It searches then all addresses. I am very interested to find the performance problem here.