Sorry, let me amend that:
> The schema is roughly
>
> create table records(__recno INTEGER PRIMARY KEY, fileId, data);
Forget the INTEGER PRIMARY KEY. My partial index would reference
the _rowid_. I don't permit vacuums on the database so, if I'm not
mistaken, this shouldn't be an issue.
--
Eric A. Smith
Parkinson's Fourth Law:
The number of people in any working group tends to increase
regardless of the amount of work to be done.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
