:sign0188:Hi,
i wanted inform about some stress tests with a SQLite Database with 135.000 Rows and 15 cols. The test are performed an a motorola defy.
I used an index on the searched field, i also used an modified version of DButils.ExecuteListview to fill a listview with two columns layout an a bitmap.
Some results:
Query: Select * from Table where Plz like '2033%'
Worktime: 1832 ms, 12 records in listview
Second example:
Query: Select * from Table where like 'böck%'
Worktime: 1188 ms, 75 records found
I had some result set's with 4000 records in listview, and the app didnt have problems to work with.
I think, that this answer times are fantastic for this amount of data, the file size is, for an database file, extrem small.
Greetings from austria
Reinhard
i wanted inform about some stress tests with a SQLite Database with 135.000 Rows and 15 cols. The test are performed an a motorola defy.
I used an index on the searched field, i also used an modified version of DButils.ExecuteListview to fill a listview with two columns layout an a bitmap.
Some results:
Query: Select * from Table where Plz like '2033%'
Worktime: 1832 ms, 12 records in listview
Second example:
Query: Select * from Table where like 'böck%'
Worktime: 1188 ms, 75 records found
I had some result set's with 4000 records in listview, and the app didnt have problems to work with.
I think, that this answer times are fantastic for this amount of data, the file size is, for an database file, extrem small.
Greetings from austria
Reinhard