Re: [sqlite] Limit of attached databases

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 04/06/13 08:14, Eleytherios Stamatogiannakis wrote: > We have tried with both views and VTs but SQLite does not create > automatic indexes on them at all. So right now, to be able to have > automatic indexes from SQLite's side we materialize all

Re: [sqlite] Limit of attached databases

On 04/06/13 17:37, Simon Slavin wrote: On 4 Jun 2013, at 3:09pm, Eleytherios Stamatogiannakis wrote: Is there any way to go beyond the SQLITE_MAX_ATTACHED limit for *read only* attached DBs? See section 11 of It's a 64-bit value, and

Re: [sqlite] Limit of attached databases

est...@gmail.com; 'General Discussion of SQLite Database' Subject: Re: [sqlite] Limit of attached databases Gcc does have a __int128_t and __uint128_t available if you're on 64-bit and have a current enough gcc (I'm using 4.4.4 and this works on Linux and Windows) Looks like a fairly easy cha

Re: [sqlite] Limit of attached databases

-boun...@sqlite.org] On Behalf Of Eleytherios Stamatogiannakis Sent: Tuesday, June 04, 2013 9:09 AM To: sqlite-users@sqlite.org Subject: [sqlite] Limit of attached databases Hi, During our work on a distributed processing system (which uses SQLite shards), we have hit the SQLITE_MAX_ATTACHED limit of att

Re: [sqlite] Limit of attached databases

On 4 Jun 2013, at 3:09pm, Eleytherios Stamatogiannakis wrote: > Is there any way to go beyond the SQLITE_MAX_ATTACHED limit for *read only* > attached DBs? See section 11 of It's a 64-bit value, and two bits are already taken up. You

[sqlite] Limit of attached databases

Hi, During our work on a distributed processing system (which uses SQLite shards), we have hit the SQLITE_MAX_ATTACHED limit of attached DBs. The way we use SQLite for distributed processing [*], is the following: - Each table is sharded into multiple SQLite DBs on different nodes of the