"Rance Hall" wrote
In reviewing the app I'm hoping to replace I found the size of the
client list is under 100 records.
Given this new information, do you still think that db cursors is
the way to go?
Using the cursor is a more scaleable solution but if you are sure you
only
ever have 100
On Tue, Sep 14, 2010 at 7:15 PM, Alan Gauld wrote:
>
> "Rance Hall" wrote
>
>> I'm using python 3.1 with py-postgresql (located at
>> http://python.projects.postgresql.org/
>>
>> I need to work through how best to paginate larger sql result sets.
>
> Its usually best to do that at the SQL level b
"Rance Hall" wrote
I'm using python 3.1 with py-postgresql (located at
http://python.projects.postgresql.org/
I need to work through how best to paginate larger sql result sets.
Its usually best to do that at the SQL level by controlling the
cursor.
I don't know PostGres but most SQL dial
I'm using python 3.1 with py-postgresql (located at
http://python.projects.postgresql.org/
I need to work through how best to paginate larger sql result sets.
my SELECT statement returns a list, I can get its len() to find out
that X records were returned
What I want to do is print the first N r
