Re: Offset/limit and looping over a large dataset

2013-03-27 Thread Stefano Crosta
Thanks Anssi for both your replies. These db interactions definitely are really beyond the scope of my knowledge, unluckily. I did try and implement an iterator such as the one that you describe in your other message, based on index column filtering - what I dislike is that it's an additional f

Re: Offset/limit and looping over a large dataset

2013-03-27 Thread Anssi Kääriäinen
On 03/27/2013 10:53 AM, Stefano Crosta wrote: Thanks Aymeric, that's true, and I should have put that link too. sadly "akaariai" who's the only one who seemed to understand a bit about it (and is a core dev) did not seem interested in bringing this any forward, so I thought I'd try to raise som

Re: Offset/limit and looping over a large dataset

2013-03-27 Thread Stefano Crosta
Thanks Aymeric, that's true, and I should have put that link too. sadly "akaariai" who's the only one who seemed to understand a bit about it (and is a core dev) did not seem interested in bringing this any forward, so I thought I'd try to raise some interest again! On Wednesday, March 27, 2013

Re: Offset/limit and looping over a large dataset

2013-03-27 Thread Anssi Kääriäinen
On 27 maalis, 10:10, Stefano Crosta wrote: > On Tuesday, March 26, 2013 10:47:34 PM UTC+1, Petite Abeille wrote: > > > On Mar 26, 2013, at 10:03 PM, Alex Gaynor > > > wrote: > > > > For what it's worth, SQL2011 does define OFFSET, finally. > > > Perhaps worthwhile mentioning as well : > > > "Do no

Re: Offset/limit and looping over a large dataset

2013-03-27 Thread Aymeric Augustin
On 27 mars 2013, at 09:10, Stefano Crosta wrote: > it would be great to see server-side cursors and/or a smarter way to iterate > make it into core. FYI this topic is tracked here: https://code.djangoproject.com/ticket/16614 -- Aymeric. -- You received this message because you are subscr

Offset/limit and looping over a large dataset

2013-03-27 Thread Stefano Crosta
On Tuesday, March 26, 2013 10:47:34 PM UTC+1, Petite Abeille wrote: > > > On Mar 26, 2013, at 10:03 PM, Alex Gaynor > > wrote: > > > For what it's worth, SQL2011 does define OFFSET, finally. > > Perhaps worthwhile mentioning as well : > > "Do not try to implement a scrolling window using LIMI