Browse by Tags

Select Really Slow

I've a db with three tables. images = wich contains the info of the image.( id | filename | width | height | private | ... ) nodes = wich contains the image id and the tag id. ( image_id | tag_id | private ) tags = wich contains tags. ( id | tag ) The user can select the images seaching by tags using...

Posted to General (Forum) by seinkraft on 05-18-2010
Odd Select performance characteristics

As part of our application we use a SQLite database to store information about messages that are sent through Exchange. I am trying to track down some odd performance degradation. As the number of records in a particular table of the database gets into the thousands (and the database size approaches...

Posted to General (Forum) by NickHall on 01-29-2010
GetSchema slow in recent versions

The performance of the GetSchema call has dropped considerably somewhere between version 1.0.47.2 and 1.0.60.0. In our case, the call to SQLiteConnection.GetSchema("Columns") went up from about 250ms to about 3500ms. We tested the six most recent releases (1.0.60.0 - 1.0.65.0) and all gave...

Posted to Bugs (Forum) by bvanreeven on 09-07-2009
[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
reading and writing BLOB fields in chunks

Hi everyone. I have a database that stores large music files as BLOB fields. The problem is that the .net provider loads the entire BLOB field into memory which causes my application to to use too much memory (and eventually crash). Is there a way to tune the .net provider so that I can load and...

Posted to General (Forum) by liron on 05-23-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
Database Connection Tuning

I need help tuning the database connection parameters. I have 2 modes. Bulk Writing - 1 connection to the database (enforced by lockout and isolation). A new database is created and tons of data is bulk loaded into the file. Maximum performance is most important. Database corruption is not a big deal...

Posted to General (Forum) by jeremyje on 02-23-2009
Trade ACID for Speed?

Hi, is it possible to give up some of the ACID compilance for performance gains in INSERT/UPDATE queries? TIA, Matthias

Posted to General (Forum) by MatthiasBiel on 09-03-2008
Performance&Size V1.0.49 CF

I just tested the new 1.0.49 release using the binary package. The good news is that it my benchmarks indicate a 10% performance gain for the desktop version. But did something go wrong with the CF version? The DLL is 779K compared to 497K in V1.0.48. Also, the new DLL is 30% slower. Did the debug version...

Posted to Bugs (Forum) by markus on 05-29-2008
SQLite performance with Datagridview

I did some tests filling a datagridview with an SQLITE table and found out some interesting points, I would like to share with you. Test envirnoment PC : AMD64 X2 Dual Core 5000+ 2GB RAM, XP Pro SP2, VS 2005 Database : table 249.000 records, 6 columns, no key, database size 13,6 MB Version : phx-sqlite...

Posted to Benchmarks (Forum) by Mark2 on 05-20-2008

Page 1 of 1 (10 items)