Displaying 1 result from an estimated 1 matches for "pragma_synchron".
2007 Oct 22
3
RSQLite indexing
I am trying to use RSQLite for storing data and I need to create indexes on
two variables in the table. It appears from searching the web that the CREATE
INDEX operation in SQLite is relatively slow for large files, and this has been
my experience as well.
The two index variables are crossed. One has about 350,000 levels [yes, it's
genetic association data]. The other will have about