in

System.Data.SQLite

An open source ADO.NET provider for the SQLite database engine
All Tags » slow (RSS)

Browse by Tags

  • Slowness in Visual Studio when use the System.Data.SQLite

    Hi! I'm using System.Data.Sqlite to develop Windows Mobile applications, but I'm having trouble editing the design UserControls, opening a UserControl, Visual Studio is too slow and gets to hang. It turns out that when I remove the reference of SQLite, normalizes the design. What might be happening...
    Posted to Bugs (Forum) by JulioDesenv on 10-28-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

  • [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

  • DataSet.Load and DataTable.Load - very slow

    Lately I've made some performance tests of System.Data.SQLite provider. I've noticed during tests of SELECT command that DataSet.Load and DataTable.Load methods are much slower compared to other methods of reading data (using DbDataReader or with DbDataAdapter.Fill method). I've got following...
    Posted to General (Forum) by KoD666 on 10-29-2008

  • View Indexes Used in Queries

    I have an application that's driven off of SQLite. It has many indexes for each table many of them seem to be used well but sometimes a simple query can lock up my app for a very long time. Usually in the order of minutes. Is there a way to see what indexes for a particular query SQLite decides to...
    Posted to General (Forum) by jeremyje on 10-25-2008

  • help: sqlite.net very slow when update

    Hello 1st I use "this.dataSet1.User_Data_Table.Rows.Add(drow);" to add 300 rows; 2nd. I use such code to write the data to the database: this.Validate(); this.userDataTableBindingSource.EndEdit(); this.user_Data_TableTableAdapter.Update(this.dataSet1.User_Data_Table); // --> this line took...
    Posted to General (Forum) by hfalls on 08-06-2008
Page 1 of 1 (7 items)
Powered by Community Server (Commercial Edition), by Telligent Systems