Browse by Tags

Cant Convert nvarchar to datetime and Datediff function not works

I used this in sqlserver DATEDIFF(Day,CAST(OldCompletionDate as datetime),CAST(StartDate as datetime)) as AgeCompletionWip but it doest now work in sqlite... Thanks in Regards

Posted to General (Forum) by crimsonland on 05-11-2011
Keeping Database Connection Open

I am using ADO.NET provider on Windows Mobile to connect to SQLite database. Will keeping database connection open for application life create any issue? I am thinking about it because, 1. It will not allow user to delete database file (as it's already in use). 2. It will not allow other processes...

Posted to General (Forum) by chintanpshah on 03-15-2011
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
SQLiteDataReader.VerifyType wastes tons of cycles

SQLiteDataReader.VerifyType only needs column affinity to work. However, it goes through GetSQLiteType to get the affinity, taking 95% of cycles to find out the DbType for the column (see chart below). In our application we don't use those SQLiteDataReader methods that need to know the column's...

Posted to Bugs (Forum) by atyk on 10-31-2010
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

Page 1 of 2 (14 items) 1 2 Next >