Re: [sqlite] build db in memory then dump to a persistent file.

2009-10-05 Thread Jeremy Hinegardner
Hi George, On Sat, Oct 03, 2009 at 01:50:31PM -0700, George Hartzell wrote: > > Hi all, > > I use an SQLite database w/ the rtree extension to hold information > about genetic polymorphism (snp's), based on UCSC's mapping work and > their mysql table dumps. My database is write-once, read from

Re: [sqlite] build db in memory then dump to a persistent file.

2009-10-03 Thread Simon Slavin
On 3 Oct 2009, at 9:50pm, George Hartzell wrote: > One of the tables has almost 19 million rows. This is the table on > which I build my 2-D rtree index. > > I read the data from tab delimited mysql dumps into the basic tables, > then run a query that pulls the data I want to rtree-index out of

[sqlite] build db in memory then dump to a persistent file.

2009-10-03 Thread George Hartzell
Hi all, I use an SQLite database w/ the rtree extension to hold information about genetic polymorphism (snp's), based on UCSC's mapping work and their mysql table dumps. My database is write-once, read from then on. One of the tables has almost 19 million rows. This is the table on which I bui