I have a quick question for users of SQLite.
I cannot seem to get a query to return more than 1000 rows in either J6.02
or J7.01.
Consider the following - I have created a simple sqlite database that
contains one table with 100,000 rows.
load 'data/sqlite'
NB. database file
file=. 'C:\mp\cs\SqliteTest00\SqliteTest00\bin\Debug\test.db'
NB. create sqlite object
]db=. file conew 'psqlite'
+--+
|10|
+--+
NB. count rows - confirms 100,000 rows
strquery__db 'select count(*) from test'
+--------+
|count(*)|
+--------+
|100000 |
+--------+
NB. fetch entire table - should return all rows.
dat=. colquery__db 'select * from test'
NB. returned row count is 1000
#&> dat
2 4
1000 1000
This looks like a row limit is set somewhere in the sqlite interface. I
cannot
find it and I cannot get the remaining rows. Clearly I am doing something
wrong
as a database that returns 1000 rows will not be very useful
--
John D. Baker
[email protected]
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
