Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

large database


Petrnek

Recommended Posts

Hi all,

 

i have a store, that doesn't have as many products (well, some thousands) but has them duplicated in many categories. This creates over 17000 items. The first initial index page rendering is over 50secs. Then, the response is faster, but still ot perfect. I populate my site through easy populate. If anyone is interested, i would be glad to provide my data for testing purposes to optimize the code.

 

Interestingly enough, when i had just one top category, all was _quite_ OK, but now, after adding second one, the performance decreased dramatically.

 

Any idea for optimization?

 

You can check it at spares.robe.cz

 

Thank you

 

Petr

Link to comment
Share on other sites

Hi all,

 

i have a store, that doesn't have as many products (well, some thousands) but has them duplicated in many categories. This creates over 17000 items. The first initial index page rendering is over 50secs. Then, the response is faster, but still ot perfect. I populate my site through easy populate. If anyone is interested, i would be glad to provide my data for testing purposes to optimize the code.

 

Interestingly enough, when i had just one top category, all was _quite_ OK, but now, after adding second one, the performance decreased dramatically.

 

Any idea for optimization?

 

You can check it at spares.robe.cz

 

Thank you

 

Petr

 

 

Wow, that's slow!

 

With that many products, you probably need to be on a dedicated server, especially if you get a lot of traffic. Shared hosting just won't cut it with a big store.

 

You might consider getting rid of the "new products for..." box, I think that uses a lot of processing power to display.

 

Check out Chemo's store optimization thread.

 

Run Analyze and then Optimize on your tables...every day.

 

Cache your categories box and get rid of the code that counts and displays the number of products on the categories box.

 

There's probably more that you can do to speed things up, but these should help a bit.

 

Ed

Link to comment
Share on other sites

Wow, that's slow!

You might consider getting rid of the "new products for..." box, I think that uses a lot of processing power to display.

...

 

Great, thank you, i will try your suggestions and will let you know:)

Cheers

 

Petr

Link to comment
Share on other sites

Wow, that's slow!

 

Ed

 

Dear Ed,

 

just turning off the count and the new products made the store rendering go down very dramatically! You can check!

 

I will look up some more things and thank you for the quick advice once again,

 

Cheers

Petr

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...