Reply to thread

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...


Top Bottom