Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to fetch more than 1000?

How can I fetch more than 1000 record from data store and put all in one single list to pass to django?

like image 520
Zote Avatar asked Nov 05 '08 01:11

Zote


People also ask

How do I query more than 1000 records in Toad?

if so, use F9 to retrieve the first 1000 and F5 to retrieve all rows. When building your query you probably do not want to see all rows until you know that you wrote the sqL correctly. hence the preview of first 1000 rows. When done and you want to see all use the F5 or right click and request to read all rows.


2 Answers

Starting with Version 1.3.6 (released Aug-17-2010) you CAN

From the changelog:

Results of datastore count() queries and offsets for all datastore queries are no longer capped at 1000.

like image 150
Shay Erlichmen Avatar answered Sep 19 '22 22:09

Shay Erlichmen


Just for the record - fetch limit of 1000 entries is now gone:

http://googleappengine.blogspot.com/2010/02/app-engine-sdk-131-including-major.html

Quotation:

No more 1000 result limit - That's right: with addition of Cursors and the culmination of many smaller Datastore stability and performance improvements over the last few months, we're now confident enough to remove the maximum result limit altogether. Whether you're doing a fetch, iterating, or using a Cursor, there's no limits on the number of results.

like image 22
Tomasz Zieliński Avatar answered Sep 18 '22 22:09

Tomasz Zieliński