Reply to thread

Message

<blockquote data-quote="doskabouter" data-source="post: 1286667" data-attributes="member: 98267">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]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; using (var sql = new SQLite.NET.SQLiteClient(@&quot;D:\klad\sqlitetest\sqlitetest\PictureDatabaseV3_1.db3&quot;))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; for (int i = 0; i &lt; 1000; i++)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var res = sql.Execute(&quot;select * from picturedata where idpicture=3856&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }[/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...</blockquote>

[QUOTE="doskabouter, post: 1286667, member: 98267"] 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... [/QUOTE]

Verification