What database are you using?

I'm finishing up a large (>200k items) Satchmo store with some offline
inventory updates, and quickly found that MySQL with MyISAM files did not go
well. I don't know about memory usage, but I was getting timeouts from the
database.

I ended up using PostgreSQL and using transaction management and things got
a lot better.  You could try InnoDB tables if you are on MySQL -- that may
also work.

Also, I discovered that I didn't have Memcache setup properly and wasn't
using it when I thought I was.  Make sure you have these in your
MIDDLEWARE_CLASSES:

'django.middleware.cache.UpdateCacheMiddleware',
'django.middleware.common.CommonMiddleware',
'django.middleware.cache.FetchFromCacheMiddleware',


I discovered this by installing memcache_status.  That gives you a view into
memcache in your admin:
http://pypi.python.org/pypi/django-memcache-status/1.0




On Tue, May 31, 2011 at 6:09 AM, ug Charlie <[email protected]> wrote:

> I think my satchmo shop takes too much memory :(
>
> I have used memcached to set my cache backend and set DEBUG false.
>
> In the server there are lots of www-data user taking memory. I have no
> idea about that.
>
> It is my first time to use satchmo and django.
>
> Could anyone give me some advice?
>
> Thank you :)
>
> --
> 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.
>
>


-- 
Mike Hostetler
SquarePeg Systems
http://www.squarepegsystems.com

-- 
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.

Reply via email to