Best Regards,
Bibin Bhanu
Working hard makes me Luckier.
-----Original Message-----
From: D. Richard Hipp [mailto:[EMAIL PROTECTED]
Sent: Fri 8/13/2004 8:04 PM
To: [EMAIL PROTECTED]
Subject: Re: [sqlite] QNX and PPC
Jakub Adamek wrote:
> Thank you for the explanation. And this file is always created even if I
> do not use TEMP tables? Because I am not using them.
>
You always have an SQLITE_TEMP_MASTER table, which is also stored in the
same temporary file.
>
> D. Richard Hipp wrote:
>
>> Jakub Adamek wrote:
>>
>>>
>>> I only wonder, what is the file SQLite creates in /tmp? My program
>>> calls "CREATE TABLE", "INSERT" and "SELECT". Why does SQLite need
>>> some temporary file?
>>>
>>
>> That temporary file is where it stores temporary tables created
>> using CREATE TEMP TABLE and so forth. Additional temporary files
>> will be created for some intermediate tables needed to evaluate
>> certain subqueries. For example, if you do
>>
>> ... WHERE x IN (SELECT a FROM table1);
>>
>> The results of the subquery are stored in a separate database file
>> created in /tmp.
>>
>
>
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
