"&virtuemart_category_id=" forces server to reset connection

[Kupernikuz]

POST UPDATE:
DATE: june the 14th 2012:
----------------------------------
Joomla: 2.5.4
VM: 2.0.6
Weather: Cloudy, windy and cold

If using the Search module in VM, the results shows up fine, but when clicking on a "Product Details" to go to the details page, the system works too long, and gives a timeout, probaly because we have a LOT of products in the system now.
Here is an example:

Visit the page: http://flensborgapotek.dk
In the search-box, type in: paracetamol
Now a list of products shows up
Click on one of the descriptions-buttons
When holding the mouse over, you can see, that  it tries to open a URL like this:
http://flensborgapotek.dk/index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=993030&virtuemart_category_id=1
- it gives a time-out.

Stripping out the ' &virtuemart_category_id=1 ' of the URL, you will see that it works, and shows the product:
http://flensborgapotek.dk/index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=993030

I've got the same problem before, with the VM module that shows featured products, but in the JRoute in that specific module, I just stripped out the part, that prints the part of the URL *&virtuemart_category_id=* and the part that asks the DB for the ID, and that just works fine.


I've been searching around in all files today, looking for somewhere to change this, but without luck yet.
Someone knows in wich file(s) I have to look?

UPDATE:
DATE: june the 14th 2012:
The reason why I want to strip out the '&virtuemart_category_id=' is, that it gives a too big load on the server, wich resets the connection, if trying to get the URL, as it seems.
But if we can get it to make fewer queries and loadtime reduces, it will be better.

After seeking all files through I still don't find wehere I can strip out the '&virtuemart_category_id=' only when showing list of products after using the Search field "mod_virtuemart_search" - see desc. above.


Best regards
Kupernikuz

[Kupernikuz]

A new update: Using Akeeba Backup and Kickstart, I moved to my own office-server, so I have a chance to see what happens. Well.. I wanted to log everything on the web and MySQL server, but its impossible. The server simply crashes. The load on RAM, and disk is normal, but the load on CPU's is 100% per core, when a user clicks on a product in VM, when trying as described above. If I try to log everything, my server simply goes in protection  mode and shuts down the connection.

[jjk]

From your description I don't have an idea what might be wrong in your case, but I would suggest to make a copy of your Joomla/VM2 installation and install Virtuemart 2.0.7f to find out if it makes a difference. There have been quite a few changes and bug fixes since version 2.0.6. (When experimenting, make shure you are working with a copy, not with your production database).