Re: [sqlite] hoe to create index to a big table - resolution

temporary storage to memory, either by compile switch or #pragma temp_store? If so, try explicitly setting #pragma temp_store=1, this will force temporary data to be stored on disk. Gerd. Hadashi, Rinat schrieb am 30.06.2014 10:30: > I work with a very big table, on Linux. > I fail to create

[sqlite] hoe to create index to a big table?

I work with a very big table, on Linux. I fail to create index getting the following error: SQL error near line 1: database or disk is full Any advice? Rinat Hadashi - Intel Israel (74) Limited This e-mail and any attachments

[sqlite] Where can I find JDBC for 3.8.2 or later?

I am looking for a JAVA sqlite JDBC version 3.8.2 or later, for Linux Rinat Hadashi - Intel Israel (74) Limited This e-mail and any attachments may contain confidential material for the sole use of the intended recipient(s).

Re: [sqlite] Reading compressed database files

Database Subject: Re: [sqlite] Reading compressed database files On 28 May 2014, at 8:25am, Hadashi, Rinat <rinat.hada...@intel.com> wrote: > My databases are very big (almost 100 GB). > I am looking for a compression solution. Are these databases with fixed data which can be open

Re: [sqlite] Reading compressed database files

: [sqlite] Reading compressed database files -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 28/05/14 00:25, Hadashi, Rinat wrote: > My databases are very big (almost 100 GB). I am looking for a > compression solution. > > Did anyone have an experience with reading a compressed databas

[sqlite] Reading compressed database files

Hi My databases are very big (almost 100 GB). I am looking for a compression solution. Did anyone have an experience with reading a compressed database? What was the degradation in performance of queries? Thanks Rinat Hadashi

Re: [sqlite] Load time performance

connection. If you're using one connection to the DB, then you'll experience the delay. If you've got one connection going for the life of your application, you'll get hit with the first delay, but all subsequent queries will work. On Thu, May 22, 2014 at 8:12 AM, Hadashi, Rinat <rinat.h

[sqlite] Load time performance

Hi The first time I access a database takes significantly more time than subsequent accesses. I am looking for ideas to shorten the time required for the first access. I work on Linux, my db. file is "somewhere" in the file system, not locally on the machine from which I am running sqlite3