Normal
Not wanting to be a nuisance but I couldn't help myself creating a small testcase1000 queries with using new sqlite: 2 seconds (db on a fast local ssd), 1000 queries inside the using[CODE] using (var sql = new SQLite.NET.SQLiteClient(@"D:\klad\sqlitetest\sqlitetest\PictureDatabaseV3_1.db3")) { for (int i = 0; i < 1000; i++) { var res = sql.Execute("select * from picturedata where idpicture=3856"); } }[/CODE]half a second.So I can imagine that there could be some systems (slow spinning rust f.e.) where this is could be slow...Edit: and I can remember (was it you [USER=68833]@ajs[/USER] with your enormous picturedatabase or was it that guy with the large music) that we even had to cut off queries halfway because they took too long...
Not wanting to be a nuisance but I couldn't help myself creating a small testcase
1000 queries with using new sqlite: 2 seconds (db on a fast local ssd), 1000 queries inside the using
[CODE]
using (var sql = new SQLite.NET.SQLiteClient(@"D:\klad\sqlitetest\sqlitetest\PictureDatabaseV3_1.db3"))
{
for (int i = 0; i < 1000; i++)
var res = sql.Execute("select * from picturedata where idpicture=3856");
}
[/CODE]
half a second.
So I can imagine that there could be some systems (slow spinning rust f.e.) where this is could be slow...
Edit: and I can remember (was it you [USER=68833]@ajs[/USER] with your enormous picturedatabase or was it that guy with the large music) that we even had to cut off queries halfway because they took too long...