Your C# code is timing the entire loop while appending to a StringBuilder.
This is going to be slower than simply running the SQLite query. I suggest
trying the following change to get a clearer picture of the time spent
executing the actual query:
cmd.Prepare();
var dtStart = En
Hi,
I have a table with 10 000 000 records
there is compound primary key (ObjectID, AttributeID)
1. when I exequte next query
SELECT * FROM ObjectValue WHERE ObjectID=4 AND AttributeID=3;
in managment tool e.g.sqliteadmin the time of execution is ~16ms
(return result : 1 row)
2. execute this
2 matches
Mail list logo
