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