[sqlalchemy] Re: Are consecutive query.get calls supposed to send a single SELECT query?

2013-05-22 Thread Etienne Rouxel
@Michael Bayer: I successfully ran your script and like my previous tests using variables to stored the results of the queries : only a single SQL query was sent. Le mardi 21 mai 2013 17:31:10 UTC+2, Etienne Rouxel a écrit : Hello In my program, I was trying to guess why so many SQL queries

[sqlalchemy] Re: Are consecutive query.get calls supposed to send a single SELECT query?

2013-05-22 Thread Etienne Rouxel
My real application seems to share the cause for why the identity map is not used. Indeed, I have a method that encapsulate the building of a form using queries. Once the execution goes out of this method, the instances are cleared out from the identity map. I guess this is a very common

[sqlalchemy] Re: Are consecutive query.get calls supposed to send a single SELECT query?

2013-05-22 Thread Etienne Rouxel
I would like that no garbage collection occurs within a session, is there a way to configure that behavior? Le mardi 21 mai 2013 17:31:10 UTC+2, Etienne Rouxel a écrit : Hello In my program, I was trying to guess why so many SQL queries were sent while some could have been avoided with the

[sqlalchemy] Re: Are consecutive query.get calls supposed to send a single SELECT query?

2013-05-21 Thread Etienne Rouxel
@Charlie Clark: In the documentation (http://docs.sqlalchemy.org/en/rel_0_8/orm/session.html#session-frequently-asked-questions see Is the Session a cache ?), it is mentioned that it does not necessarily performs a query. @Simon King: I guess you're the King indeed, I tried: 1. to assign the

[sqlalchemy] Re: Are consecutive query.get calls supposed to send a single SELECT query?

2013-05-21 Thread Etienne Rouxel
@Michael Bayer: The database type used is integer with a range from -2147483648 to +2147483647 according to the documentation (http://www.postgresql.org/docs/8.4/interactive/datatype-numeric.html). I just started at the beginning of the range, that is why I have negative numbers. I performed