in

System.Data.SQLite

An open-source, enhanced version of the SQLite database engine for Windows
All Tags » SELECT performance (RSS)

Browse by Tags

  • How to speed up dataGridView filling

    Hi, I'm having a problem with slow dataGridView filling. My table has ~400000 records and it takes about 53 seconds to load the data in my code, while in SqliteAdmin it takes only 9 seconds. Here is the code : DataSet ds = new DataSet(); string sql = "SELECT rowid, length,sec,usec,sip,dip,protocol...
    Posted to How To (Forum) by Sakyamuni on 03-29-2008

  • Slow SELECT

    Hi, I'm using with success sqlite, but I have a little performace problem in a simple select. I have a table with this definition CREATE TABLE ClientiFornitori ( [id_clifor] GUID ,[Tipo] int ,[Codice] int ,[RagioneSociale] varchar(300) ,[NomeSemplificato] varchar(300) ,[Indirizzo] varchar(100) ,...
    Posted to How To (Forum) by vuemme on 08-06-2007
Page 1 of 1 (2 items)
Powered by Community Server (Commercial Edition), by Telligent Systems