Jeffrey Horner <[EMAIL PROTECTED]> writes: > Thomas Lumley wrote on 10/22/2007 04:54 PM: >> 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.
What is your schema? In particular, are things that are integers or floats being stored that way in SQLite? I believe the annotation data packages via AnnotationDbi are using cache_size=64000 and synchronous=0 and that this was determined by a handful of experiments on typical annotation dbs. Columns with few levels may not benefit from an index. See this thread: http://thread.gmane.org/gmane.comp.db.sqlite.general/23683/focus=23693 But your column with many levels should suffer this problem :-) + seth -- Seth Falcon | [EMAIL PROTECTED] | blog: http://userprimary.net/user/ ______________________________________________ R-devel@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-devel
