Stop stop stop > create table x > ( > id integer primay key, > data blob > );
I did not see this until searching for the word PRIMARY and not finding it. Thus id is not a primary key at all. Probably it is a good habit to always add WITHOUT ROWID when there is an explicit primary key. The SQL parser would then have reported an error. The tests with individual rows must definitely be repeated. In my tests the results are closer together: Method 1: Retrieve Individual Row 00:00:00.081151 10000 Method 3: using dynamic in 00:00:00.060368 9995 Method 5: using in carray 00:00:00.050884 9995 Method 5: using carray join 00:00:00.043127 10000 Method 6: Using temp table 00:00:00.060808 9995 (for oarameter = 10000) I tuned the Python script, using fetchone() in the individual row test. And I added a temp table test. In Python this just uses executemany() to insert the rowset. Thanks, E. Pasma _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
