diana wrote: > And now for a question about a completely different app (no sharding, > very simple). I haven't got a sufficient response from the pylons > group, so I'm trying here. > > The question: > > http://groups.google.com/group/pylons-discuss/browse_thread/thread/cb48d0ea2b084159 > > Things I've tried/considered: > > --- mysql & utf8 memory issues > --- different mapping approaches (base declarative, reflective, etc) > --- various debug options and non-production standard settings > --- beaker (although I'm not sure that I successfully turned it all > off, I'll keep trying) > --- indexes > --- added tests for old-school classes (ones that don't extend object > and aren't garbage collected) > --- I've played with dozer (added to middleware.py, didn't find much > -- old-school classed, maybe?) > > You wouldn't know it from my deluge of recent questions, but in all my > years at this I've only asked these three threads worth of questions, > plus an X11 one years and years ago on the the OpenBSD group. Anyway, > I do apologize for having to ask so much from you and this group -- > perhaps I'll be able to start giving back soon by answering some of > the questions.
the Python VM doesn't shrink very much in size once it's grown. GC can let go of everything but the VM size is there for good. Your query of 90K rows is growing it because MySQLdb fully buffers result sets before making them available. this is a MySQLdb limitation. > > Sorry, > > --diana > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to sqlalch...@googlegroups.com. > To unsubscribe from this group, send email to > sqlalchemy+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > > >
-- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
