Re: [sqlalchemy] Unexplainable SQL queries / Performance issues

2012-11-22 Thread Diana Clarke
/session creation, data population, etc), so that I have a better chance of seeing what you're seeing? http://pastebin.com/mcum0c7Q --diana On Thu, Nov 22, 2012 at 6:09 AM, Martin84 steko...@googlemail.com wrote: Hi Diana, thank you for your help, but unfortunately my problem still exists

Re: [sqlalchemy] Unexplainable SQL queries / Performance issues

2012-11-21 Thread Diana Clarke
the question. Cheers, --diana On Wed, Nov 21, 2012 at 3:25 AM, Martin84 steko...@googlemail.com wrote: Hi, I use SQLalchemy 0.7.9 with SQLite and have a performance issue. I have a simple database with joined table inheritance and some relationships. In short: I have a base class Human

Re: [sqlalchemy] Re: cherrypy SA 0.7 scoped_session

2011-12-08 Thread Diana Clarke
=engine))    session = Session() In the two-file version, restresource.py isn't getting the 'Session' you created in two_file_server.py, but rather a new blank one from the import statement. Hope that helps, --diana On Thu, Dec 8, 2011 at 8:41 PM, John Hufnagle johnjhufna...@gmail.com wrote: Thanks

Re: [sqlalchemy] Re: cherrypy SA 0.7 scoped_session

2011-12-08 Thread Diana Clarke
with your own values. Session = scoped_session(sessionmaker(bind=engine))session = Session() In the two-file version, restresource.py isn't getting the 'Session' you created in two_file_server.py, but rather a new blank one from the import statement. Hope that helps, --diana On Thu, Dec 8

[sqlalchemy] IS NULL filter, non-NULL row returned

2010-10-26 Thread Diana Clarke
AND user.id IS NULL sqlalchemy.engine.base.Engine.0x...eb2c: INFO: (1,) sqlalchemy.engine.base.Engine.0x...eb2c: DEBUG: Col ('user_id', 'user_username', 'user_level') sqlalchemy.engine.base.Engine.0x...eb2c: DEBUG: Row (5L, u'jane', 1) Thanks, --diana -- You received this message because you

Re: [sqlalchemy] IS NULL filter, non-NULL row returned

2010-10-26 Thread Diana Clarke
Wow, I want to unlearn this. For the benefit of some ODBC applications, the following query can be used to find a newly inserted row: ... SELECT * FROM tbl_name WHERE auto IS NULL; All further executions of the same statement provide the expected result Thanks, Michael! --diana On Tue, Oct

Re: [sqlalchemy] session lifecycle and wsgi

2010-04-28 Thread Diana Clarke
to do pagination, saves, deletes, etc. I dunno... Thanks fro asking Chris. I'm watching the answers to these threads too. --diana On Wed, Apr 28, 2010 at 9:37 AM, Chris Withers ch...@simplistix.co.ukwrote: Hi All, I'm still trying to get an answer on this... Am I right in understanding

Re: [sqlalchemy] session lifecycle and wsgi

2010-04-28 Thread Diana Clarke
rollbacks even for non-transactional database engines. InvalidRequestError: Can't reconnect until invalid transaction is rolled back It goes without saying, but perhaps I've misunderstood something... --diana On Wed, Apr 28, 2010 at 10:52 AM, Chris Withers ch...@simplistix.co.uk wrote

Re: [sqlalchemy] SQLAlchemy 0.6.0 released

2010-04-20 Thread Diana Clarke
Yes, Congratulations Thank-you! --diana On Sun, Apr 18, 2010 at 8:02 PM, Michael Bayer mike...@zzzcomputing.com wrote: The first official 0.6 release of SQLAlchemy is now available. -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post

[sqlalchemy] eagerload -- unknown column None in field list

2010-02-05 Thread diana
column 'None' in 'field list') Any ideas off the top your head? PS. I can traverse lazily to the child collection, no problem. Cheers, --diana -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalch

Re: [sqlalchemy] Sharding - same table definitions yet different (but predictable) table names... thousands of them

2010-01-11 Thread Diana Clarke
question... which I might ask shortly ;) Thanks again for your time, --diana On Fri, Jan 8, 2010 at 10:32 AM, Michael Bayer mike...@zzzcomputing.com wrote: how does your application want to reference these tables ?   while this might be a little memory consuming I'd probably look into generating

[sqlalchemy] why query_chooser rather than shard_chooser in this case?

2010-01-11 Thread diana
in this case? Hope that was clear enough. Thanks again for your time, --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

Re: [sqlalchemy] why query_chooser rather than shard_chooser in this case?

2010-01-11 Thread Diana Clarke
out the deferred property, it behaves as I would suspect (one query_chooser call). Ok, that answers Question #1. Question #2 similar, but w/ session.add(). I'll send a new email for Question #2. Thanks, --diana On Mon, Jan 11, 2010 at 3:25 PM, Michael Bayer mike...@zzzcomputing.com wrote

Re: [sqlalchemy] why query_chooser rather than shard_chooser in this case?

2010-01-11 Thread Diana Clarke
? Is there some way I can optimize this case, perhaps by setting the shard_id somewhere, so that 4 queries aren't executed in this case? Thanks, --diana On Mon, Jan 11, 2010 at 3:38 PM, Diana Clarke diana.joan.cla...@gmail.com wrote: Question #2 similar, but w/ session.add(). I'll send a new email

Re: [sqlalchemy] why query_chooser rather than shard_chooser in this case?

2010-01-11 Thread Diana Clarke
Thanks, Michael. This will take me a bit to digest, and I'm about to start the second shift as wife and mother... tomorrow maybe. Thanks again for the quick responses -- greatly exceeding expectations! Cheers, --diana On Mon, Jan 11, 2010 at 5:14 PM, Michael Bayer mike...@zzzcomputing.com

[sqlalchemy] pylons SQLAlchemy memory

2010-01-11 Thread diana
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. Sorry, --diana -- You received this message because you

Re: [sqlalchemy] pylons SQLAlchemy memory

2010-01-11 Thread Diana Clarke
On Mon, Jan 11, 2010 at 7:07 PM, Antoine Pitrou solip...@pitrou.net wrote: Le lundi 11 janvier 2010 à 15:55 -0800, diana a écrit : Well if you only want to count entries, use Query.count(), not Query.all(). Yup, I don't actually do this in a real app. I was just doing this (in a hello world

Re: [sqlalchemy] pylons SQLAlchemy memory

2010-01-11 Thread Diana Clarke
I never really suspected that this was a SQLAlchemy issue, which was why I didn't originally post this question to the SQLAlchemy group. I apologize if it came across that way. Time for me to do my python VM homework... My apologies, --diana On Mon, Jan 11, 2010 at 8:15 PM, Michael Bayer mike

[sqlalchemy] Re: Sharding - same table definitions yet different (but predictable) table names... thousands of them

2010-01-08 Thread diana
table_circle_number all share the same table definition, but have different names (numbers). Same goes for table_square_number, etc. The number in table_square_number is used to determine which shard to look in (1...N). Each shard is responsible for a range of numbers. --diana -- You received this message

[sqlalchemy] Sharding - same table definitions yet different (but predictable) table names... thousands of them

2010-01-07 Thread diana
-- table_square... -- table_square_M Let's say M = 1000, table_circle_1 ... table_circle_M share the same definition, and table_square_1 ... table_square_M share the same definition, etc. Hope that was clear enough. Thanks for your time, --diana -- You received this message because you