On 21 Mar 2019, at 4:04pm, Hick Gunter <[email protected]> wrote: > CREATE TABLE logidx( keyid INTEGER, value BLOB, timestamp INTEGER, primary > key (keyid, value, location) ) WITHOUT ROWID;
Can't answer the question you posed and I'm happy to see Igor could. But I wanted to speak against including a BLOB field in a compound PRIMARY KEY. The PRIMARY KEY gets used a lot when SQLite does anything with a row, and having to match a whole BLOB and then compound it is going to take some time. I think it would be faster to let SQLite do its normal rowid thing and define the above PRIMARY KEY as a UNIQUE INDEX instead. Of course, it may be faster or more convenient to you in some other way in which case I stand corrected. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
