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].
For more options, visit this group at
http://groups.google.com/group/satchmo-users?hl=en.
