diff options
author | 2009-05-06 16:45:59 -0700 | |
---|---|---|
committer | 2009-05-21 15:22:28 -0700 | |
commit | ab18d1f46a0501f9a54da1ef08ff4967f4b63b68 (patch) | |
tree | 954eb382bf8961e80bb944d795cd90391854fd8d /libs/rs/rsScript.cpp | |
parent | d1874747c281e3277980fe7318f9007643a25f60 (diff) |
Fix SQLite limit issue.
SQLLite limit is not only used to limit the returned number of data.
It can be used to do an offset query.
For example, "SELECT * FROM table LIMIT 100, 10", will return the
data of index in the range of [100, 100 + 10).
This change set enable this kind of useage.
This is also more efficient than use "cursor.moveToPosition()".
In my experiment, I query 1000 items in batch mode, i.e.,
get 20 items out of 1000 each time.
Time of using LIMIT clause: 626ms
Time of useing "cursor.moveToPosition()": 2062ms
Diffstat (limited to 'libs/rs/rsScript.cpp')
0 files changed, 0 insertions, 0 deletions