Browse by Tags

Very slow SQLiteDataReader.Read on Queries with LIKE in Compact Framework

I have table with 35 cols (integer, varchar(255) and datetime types) and 21171 rows. All searchable columns indexed, have primary key in integer column. Database stored on HDD for debug in Device Emulator, used last 1.0.66 version of System.Data.SQLite. When I make strong search query ("="...

Posted to Bugs (Forum) by undead on 01-07-2011
[Resolved] Inserts get slower and slower after 100 000+ rows

Hello, yes, i'm doing everthing inside a single transaction, with a single prepared command ;-) I would like to insert ~1 000 000 rows in a classic SQLite file db, and everything works fine until about 100 000 rows (~5 000 row/sec). After that, it's horribly slow like 500 row/sec or less. Any...

Posted to Bugs (Forum) by freekk on 08-28-2009
Re: Improving speed on Pocket PC

I ran into a similar situation. I was using parameterized queries to perform inserts/updates/deletes for a desktop application. The initial inserts down onto the client could exceed 400,000 inserts for a given table while after that I just pushed down changes. This works well and is lightning fast on...

Posted to General (Forum) by Nazguy on 02-26-2009

Page 1 of 1 (3 items)

System.Data.SQLite