Gsyfuy

Strange Sign on Lab Door

Why isn't there a non-conducting core wire for high-frequency coil applications

How to say "Brexit" in Latin?

Porting Linux to another platform requirements

How to prevent cleaner from hanging my lock screen in Ubuntu 16.04

What is 6÷2×(1+2) =?

Why do neural networks need so many training examples to perform?

Can a hotel cancel a confirmed reservation?

How to remove blank page before my new report chapter?

Is it a fallacy if someone claims they need an explanation for every word of your argument to the point where they don't understand common terms?

Blindfold battle as a gladiatorial spectacle - what are the tactics and communication methods?

Can an insurance company drop you after receiving a bill and refusing to pay?

Why publish a research paper when a blog post or a lecture slide can have more citation count than a journal paper?

One Half of Ten; A Riddle

Caruana vs Carlsen game 10 (WCC) why not 18...Nxb6?

What is the most triangles you can make from a capital "H" and 3 straight lines?

Am I a Rude Number?

Why exactly do action photographers need high fps burst cameras?

How can I get my players to come to the game session after agreeing to a date?

Which one of these password policies is more secure?

How can I deliver in-universe written lore to players without it being dry exposition?

Why did other German political parties disband so fast when Hitler was appointed chancellor?

In Linux what happens if 1000 files in a directory are moved to another location while another 300 files were added to the source directory?

Can making a creature unable to attack after it has been assigned as an attacker remove it from combat?

Magento 1.6.2 CE: Bundle Load Time

Magento Bundles (Long MYSQL Query)Bundle Products are being double discountedLoad Simple Products' Description in Bundle-ProductsBundle, only Required OptionsBundle item quantity sets to 1Bundle Product Quantity not loadbundle magento override getPriceTypeSelectHtmlBundle product to look as Single productIs it possible to delete price per item in bundle product?Bundle product | Duplicate bundle item optionBundle Product (Bundle Items option is missing in Admin )

0

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.

bundle magento1.6.2

share|improve this question

edited 12 mins ago

Teja Bhagavan Kollepara

2,96341847

asked Oct 10 '13 at 9:53

Adam KernigAdam Kernig

1588

add a comment | 

0

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.

bundle magento1.6.2

share|improve this question

edited 12 mins ago

Teja Bhagavan Kollepara

2,96341847

asked Oct 10 '13 at 9:53

Adam KernigAdam Kernig

1588

add a comment | 

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.

bundle magento1.6.2

share|improve this question

edited 12 mins ago

Teja Bhagavan Kollepara

2,96341847

asked Oct 10 '13 at 9:53

Adam KernigAdam Kernig

1588

share|improve this question

edited 12 mins ago

Teja Bhagavan Kollepara

2,96341847

asked Oct 10 '13 at 9:53

Adam KernigAdam Kernig

1588

share|improve this question

edited 12 mins ago

Teja Bhagavan Kollepara

2,96341847

asked Oct 10 '13 at 9:53

Adam KernigAdam Kernig

1588

edited 12 mins ago

Teja Bhagavan Kollepara

2,96341847

edited 12 mins ago

Teja Bhagavan Kollepara

2,96341847

asked Oct 10 '13 at 9:53

Adam KernigAdam Kernig

1588

asked Oct 10 '13 at 9:53

Adam KernigAdam Kernig

1588

2 Answers
2

active

oldest

votes

1

The first step is profiling.

• Install and configure Aoe_Profiler
  


• Log the SQL Queries that are executed (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.

share|improve this answer

answered Oct 10 '13 at 10:08

FlorinelChisFlorinelChis

2,08222039

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hi Florinel, Thanks for the info, the server is 8GB on its own, I do think 15000 records in 37 seconds is quite fast, but as i am no DBA I cant refer to how fast it should/could be. Also to note, I got the query log, thats how I knew it was searching for the 15,000 ID's.
  
  – Adam Kernig
  Oct 10 '13 at 11:24
  
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks for the Direction, Aoe Profiler im going to get added, it looks brilliant, a long with New Relic I might be able to narrow down other bottlenecks on the system.
  
  – Adam Kernig
  Oct 13 '13 at 16:12
  

  
  
  
  

add a comment | 

0

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

share|improve this answer

edited May 23 '17 at 12:37

Community♦

1

answered Oct 10 '13 at 10:10

user2935

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hi Serpyre thanks for your inpolite response, If you also read through the question you will have noticed I have also done a clean install replicated the database which concludes it is the actual structure within magento, hence me asking the above question on suggestions.
  
  – Adam Kernig
  Oct 10 '13 at 11:27
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Clean install then replicated the database, so yes magento's structure is exactly the same, the database is not, I am confirming the load time issue is with magento's code in requesting all simple product id's (in the bundle). Whichever way you look at it hardware or not, magento's bundle code runs the query. This is where the bottleneck is. I can confirm the structure of server can be better suited. However isnt needed at the moment. So back to my original question. Im looking for suggestions to lead me in the right direction, to remove the query and be lead to a different method.
  
  – Adam Kernig
  Oct 13 '13 at 16:07
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I think one of tests I will do is put up an identical server withour magento (Just the database) move the LIVE database to it, run the query and see if its sped up, then I'll know its apache and mysql spreading resources, from there I will look at optimising the database seperately apply some load balancers and web servers and look at results.
  
  – Adam Kernig
  Oct 23 '13 at 17:20
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "479"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f9223%2fmagento-1-6-2-ce-bundle-load-time%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

1

The first step is profiling.

• Install and configure Aoe_Profiler
  


• Log the SQL Queries that are executed (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.

share|improve this answer

answered Oct 10 '13 at 10:08

FlorinelChisFlorinelChis

2,08222039

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hi Florinel, Thanks for the info, the server is 8GB on its own, I do think 15000 records in 37 seconds is quite fast, but as i am no DBA I cant refer to how fast it should/could be. Also to note, I got the query log, thats how I knew it was searching for the 15,000 ID's.
  
  – Adam Kernig
  Oct 10 '13 at 11:24
  
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks for the Direction, Aoe Profiler im going to get added, it looks brilliant, a long with New Relic I might be able to narrow down other bottlenecks on the system.
  
  – Adam Kernig
  Oct 13 '13 at 16:12
  

  
  
  
  

add a comment | 

1

The first step is profiling.

• Install and configure Aoe_Profiler
  


• Log the SQL Queries that are executed (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.

share|improve this answer

answered Oct 10 '13 at 10:08

FlorinelChisFlorinelChis

2,08222039

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hi Florinel, Thanks for the info, the server is 8GB on its own, I do think 15000 records in 37 seconds is quite fast, but as i am no DBA I cant refer to how fast it should/could be. Also to note, I got the query log, thats how I knew it was searching for the 15,000 ID's.
  
  – Adam Kernig
  Oct 10 '13 at 11:24
  
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks for the Direction, Aoe Profiler im going to get added, it looks brilliant, a long with New Relic I might be able to narrow down other bottlenecks on the system.
  
  – Adam Kernig
  Oct 13 '13 at 16:12
  

  
  
  
  

add a comment | 

The first step is profiling.

• Install and configure Aoe_Profiler
  


• Log the SQL Queries that are executed (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.

share|improve this answer

answered Oct 10 '13 at 10:08

FlorinelChisFlorinelChis

2,08222039

share|improve this answer

answered Oct 10 '13 at 10:08

FlorinelChisFlorinelChis

2,08222039

answered Oct 10 '13 at 10:08

FlorinelChisFlorinelChis

2,08222039

answered Oct 10 '13 at 10:08

FlorinelChisFlorinelChis

2,08222039

0

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

share|improve this answer

edited May 23 '17 at 12:37

Community♦

1

answered Oct 10 '13 at 10:10

user2935

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hi Serpyre thanks for your inpolite response, If you also read through the question you will have noticed I have also done a clean install replicated the database which concludes it is the actual structure within magento, hence me asking the above question on suggestions.
  
  – Adam Kernig
  Oct 10 '13 at 11:27
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Clean install then replicated the database, so yes magento's structure is exactly the same, the database is not, I am confirming the load time issue is with magento's code in requesting all simple product id's (in the bundle). Whichever way you look at it hardware or not, magento's bundle code runs the query. This is where the bottleneck is. I can confirm the structure of server can be better suited. However isnt needed at the moment. So back to my original question. Im looking for suggestions to lead me in the right direction, to remove the query and be lead to a different method.
  
  – Adam Kernig
  Oct 13 '13 at 16:07
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I think one of tests I will do is put up an identical server withour magento (Just the database) move the LIVE database to it, run the query and see if its sped up, then I'll know its apache and mysql spreading resources, from there I will look at optimising the database seperately apply some load balancers and web servers and look at results.
  
  – Adam Kernig
  Oct 23 '13 at 17:20
  

  
  
  
  

add a comment | 

0

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

share|improve this answer

edited May 23 '17 at 12:37

Community♦

1

answered Oct 10 '13 at 10:10

user2935

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hi Serpyre thanks for your inpolite response, If you also read through the question you will have noticed I have also done a clean install replicated the database which concludes it is the actual structure within magento, hence me asking the above question on suggestions.
  
  – Adam Kernig
  Oct 10 '13 at 11:27
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Clean install then replicated the database, so yes magento's structure is exactly the same, the database is not, I am confirming the load time issue is with magento's code in requesting all simple product id's (in the bundle). Whichever way you look at it hardware or not, magento's bundle code runs the query. This is where the bottleneck is. I can confirm the structure of server can be better suited. However isnt needed at the moment. So back to my original question. Im looking for suggestions to lead me in the right direction, to remove the query and be lead to a different method.
  
  – Adam Kernig
  Oct 13 '13 at 16:07
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I think one of tests I will do is put up an identical server withour magento (Just the database) move the LIVE database to it, run the query and see if its sped up, then I'll know its apache and mysql spreading resources, from there I will look at optimising the database seperately apply some load balancers and web servers and look at results.
  
  – Adam Kernig
  Oct 23 '13 at 17:20
  

  
  
  
  

add a comment | 

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

share|improve this answer

edited May 23 '17 at 12:37

Community♦

1

answered Oct 10 '13 at 10:10

user2935

share|improve this answer

edited May 23 '17 at 12:37

Community♦

1

answered Oct 10 '13 at 10:10

user2935

edited May 23 '17 at 12:37

Community♦

1

edited May 23 '17 at 12:37

Community♦

1