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

Thanks Rinat -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of GB Sent: Monday, June 30, 2014 9:15 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] hoe to create index to a big table? Do you possibly have redirected

[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

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

On 06/30/2014 03:30 PM, Hadashi, Rinat wrote: 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 A CREATE INDEX on a large table uses temporary files to sort the data before creating the actual index

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

On 2014/06/30 10:30, Hadashi, Rinat wrote: 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? Hi Rinat - I was going to simply say Get a bigger harddrive? with a smile attached. Obviously you

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

Do you possibly have redirected 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