On Aug 28, 2008, at 12:18 AM, PyDevler wrote:
I am using the ORM query strategy using session.query. I vaguely
remember seeing in the past that doing a slice on the result set, i.e.
result[:10] used to perform a Limit/Offset query, it may not have been
so. Nevertheless, with SA 0.5beta3
On Aug 28, 2008, at 12:40 PM, PyDevler wrote:
Hi Michael,
(Sorry for the repost at sqlalchemy-devel I was not able to find this
post, so I thought it didnt go through)
I can write up a small sample later. When I turn echoing on the DB
engine, I can see that doing:
query[start:end]
Hi Michael,
(Sorry for the repost at sqlalchemy-devel I was not able to find this
post, so I thought it didnt go through)
I can write up a small sample later. When I turn echoing on the DB
engine, I can see that doing:
query[start:end]
issues the full query, not using limit, offset.
On Aug 28, 10:50 am, Michael Bayer [EMAIL PROTECTED] wrote:
I cant reproduce query[start:end] not producing LIMIT/OFFSET.
Actually that is right:
query[start:end]
does produce limit/offset. What I was doing was:
query[:end]
Since in lists start defaults to 0, that does not produce a
On Aug 28, 2008, at 2:59 PM, PyDevler wrote:
On Aug 28, 10:50 am, Michael Bayer [EMAIL PROTECTED] wrote:
I cant reproduce query[start:end] not producing LIMIT/OFFSET.
Actually that is right:
query[start:end]
does produce limit/offset. What I was doing was:
query[:end]
Since