Displaying 2 results from an estimated 2 matches for "default_cache_size".
2005 Apr 15
1
How can I change SQLite cache size for R session?
How can I change SQLite cache size for R session?
SQLite cache size can be set by a pragma, for the
duration of the session - or by default.
.pragma cache_size
.pragma default_cache_size
my questions are about RSQLite, version 0.4, running
on Windows:
- what is the cache size set to when SQLite is
invoked from R?
- if the page_size is set to 4096 what will be the
cache size in bytes when cache_size 1000 is specified?
(in other words: does R know about the page size
setting?)...
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