Livesettings use database only after start with the empty cache (memcached). The same database value is later never accessed by livesettings.
Very useful is Paginator in category template [1] and limiting the number of displayed search results etc. > is performance work planned for the future? I have much more categories and products. Unfortunately my model is also more complicated and most of my temporary optimizations would not be generally acceptable or backward compatible. I published some small and clear satchmo optimizations, something also for debug toolbar, because it especially did not like a lot of queries. I want to do bigger optimizations later in cooperation with internals of Django database layer. [1] http://docs.djangoproject.com/en/1.2/topics/pagination/ On 19 led, 23:36, Chris Moffitt <[email protected]> wrote: > 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.
