I am trying to find how I can resolve a magento issue, from what I can see when Im listing a bundle product in magento, I click 'bundle items' which does an ajax post and retrieves the data. The actual request to mysql requests all the simple product id's, because we have in excess of 15,000 simple products, this load time is around 37 seconds.
Im looking for suggestions to lead me in the right direction, to remove the query and be lead to a different method.
The first step is profiling.
lib/Varien/Db/Adapter/Pdo/Mysql.php: $_logAllQueries, $debug, and so on)This should provide you a high level overview, you can also do a more in-depth profiling with xdebug and webgrind
This should point you to the part of the code that takes a long time. By the looks of it, maybe the full product collection in loaded then something else happens.
Another thing, that shouldn't be ignored is the hardware. Where are you running this? If it's a vagrant machine with really low resources allocated, this would not be a surprise.
Of course, you cannot ask Magento to perform that kind of thing on inadequate hosting, which is what it normally comes down to.
Is there a particular reason you posted the question multiple times even though the answer was already given, hosting (and a distant second a clean install or trying to switch off all extensions). We guess you are on shared hosting, it is logical that it performs a retrieval of all products for association in admin. You cannot expect people to use their time looking at something that is standard Magento, caused by your overusing the system without providing it the resources to run, and the fact that you don't like the answer given even though it is the correct one. It is unreasonable.
https://stackoverflow.com/questions/18787073/magento-bundle-products-long-server-request
Magento Bundles (Long MYSQL Query)
Insanity: doing the same thing over and over again and expecting different results. - Albert Einstein
