Re: [sqlite] DB Partitioning and Performance

2016-05-27 Thread Michael Hari
the suggestion from R Smith that I filter those sub-selects. Hopefully it works. Thanks Simon and R Smith! On 5/27/16, 5:29 AM, "sqlite-users-boun...@mailinglists.sqlite.org on behalf of Simon Slavin" wrote: > >On 27 May 2016, at 3:17am, Michael Hari wrote: > >&g

[sqlite] DB Partitioning and Performance

2016-05-26 Thread Michael Hari
I have a database that contains 2014,2015 and 2016’s worth of data broken down by year and quarter. In total, this db was 2.36 GB. Because of a replication requirement where the DB has to be under 2 GB, I’ve split the DB into 3 smaller databases by year (2014.db,2015.db,2016.db). I would need t

Re: [sqlite] Attach Database and Database pooling

2016-05-26 Thread Michael Hari
Never mind, there was an error in my code. On 5/26/16, 11:52 AM, "sqlite-users-boun...@mailinglists.sqlite.org on behalf of Michael Hari" wrote: >Hi All, > > > >I’m trying to preallocate about 20 sqlite connections each with the same >“ATTACH DB” command. I’m ge

[sqlite] Attach Database and Database pooling

2016-05-26 Thread Michael Hari
Hi All, I’m trying to preallocate about 20 sqlite connections each with the same “ATTACH DB” command. I’m getting “database x already in use” errors. Is this not possible to do? Can each independent X connection not have the same attached DB command? If not, what’s the preferred approach? Than

Re: [sqlite] Binary Difference in Sqlite database files instead of SQLdiff and patch ?

2016-05-25 Thread Michael Hari
4 May 2016, at 6:04pm, Michael Hari wrote: > >> I’ve come to the conclusion that I would need to “split the file into two >> databases” as well. The challenge here is that the larger db will have to >> have a limit of 2 GB and will need to make a new db when it hits that limi

Re: [sqlite] Binary Difference in Sqlite database files instead of SQLdiff and patch ?

2016-05-24 Thread Michael Hari
Hi Simon, We don’t want to zip up the entire db unfortunately. It would be around 250 MB zipped versus having Sparkle update with a 38 MB patch. (Bandwidth costs are important for us) I’ve come to the conclusion that I would need to “split the file into two databases” as well. The challenge he