mercredi 30 décembre 2015

DataAdapter.Fill is slower in SQLite than SQLServer

I trying to load about 100k rows from SQLite database into a datatable. Fill method requires about 2 seconds for entire operation. I noticed that doing the same operation with SQLServer 2014 database, it requires only 0,7 secs! This is my code:

SQLiteDataAdapter adpt= new SQLiteDataAdapter("SELECT * FROM myTable", sqliteCn);
DataTable dt = new DataTable();
adpt.Fill(dt);

The table has 9 columns, 1 primary key and 1 unique index. Does SQLite is truly slower than SQL Server? If no, there are some specific operations to speed up this query?

Aucun commentaire:

Enregistrer un commentaire