We have made some improvements to the queries in satchmo-tip. Could you update to tip and see what the numbers look like.
I'm sure there is still room for improvement but it's a better base to start from. -Chris On Wed, Jan 19, 2011 at 3:00 PM, Jeff <[email protected]>wrote: > Hello all, I had a couple questions concerning satchmo's database > access. > > I installed the latest version of satchmo (.9.1 at time of post) into > a local development environment to get familiar with it. We are > planning on using it for a virtual products store (downloads, etc.) so > I created a custom product type, added 1000 products (of the default > type) and 30 categories and started playing around with it. I have > django debug toolbar installed and was looking at the query count > because I was curious if it was going to scale well. We were planning > on having around 100 categories and ~2-3k products. I was surprised at > the number of queries each page generated. Here are the numbers I was > getting with django_debug_toolbar: > > On category page with 30 products: > Queries: 660 > > On cart page with 19 Products with quantities all <= 10: > Queries: 987 > > On checkout page with 19 products with quantities all <= 10: > Queries: 725 > > On home page with 3 featured products and 30 categories: > Queries: 412 > > I believe some 40-50 of these are livesettings and could be eliminated > by using the settings file instead of the database. With strong enough > caching we could probably still provide decent performance, but these > counts seem very excessive. I proceeded to add another custom product > type and without creating any of those products it brought the query > count up by quite a bit (40+/page). > > Are these normal numbers for query counts? If so, is performance work > planned for the future? > > Thank you for your time! > > > ===Helpful Information=== > > Data: > Categories: ~30 > Products: ~1000 > > Customizations: > Added 2 custom product types. The products used in the tests were not > of these types. > > With Applications: > INSTALLED_APPS = ( > 'django.contrib.auth', > 'django.contrib.contenttypes', > 'django.contrib.sessions', > 'django.contrib.sites', > 'django.contrib.messages', > 'django.contrib.admin', > 'debug_toolbar', > 'registration', > 'sorl.thumbnail', > 'south', > 'keyedcache', > 'livesettings', > 'l10n', > 'satchmo_utils.thumbnail', > 'satchmo_store.contact', > 'tax', > 'tax.modules.no', > 'tax.modules.area', > 'tax.modules.percent', > 'shipping', > 'product', > 'product.modules.configurable', > 'product.modules.custom', > 'product.modules.subscription', > 'payment', > 'payment.modules.dummy', > 'payment.modules.paypal', > 'payment.modules.giftcertificate', > 'satchmo_ext.wishlist', > 'satchmo_utils', > 'store', # This app is currently empty except for the app below > and a templates folder > 'store.virtual_product', #This is 1 custom product type app > 'app_plugins', > 'satchmo_store.shop', > 'store.dumdum', #This is a second dummy custom product type app > ) > > -- > You received this message because you are subscribed to the Google Groups > "Satchmo users" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<satchmo-users%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/satchmo-users?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Satchmo users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/satchmo-users?hl=en.
