On Nov 20, 2008, at 8:47 PM, Michael Bayer wrote:
>> The first scenario is a single table with 24,000 rows. The problem is >> that using SQLAlchemy through Elixir to map this table to an object, >> and performing a fairly naive MappedThing.query().all() the process >> takes roughly 4.8 seconds to return every item! you know, I read this as 4.8 seconds for the full result set. 4.8 seconds per item means something is extremely wrong. SQLA can fetch 20,000 rows generally in under two seconds, so please post some test code so we can see where you're going wrong. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" 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/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
