Re: [sqlite] Use of etilqs-files

[Simon Slavin]

On 10 Sep 2014, at 1:26pm, Richard Hipp  wrote:

> The etilqs files are used (on Windows only) to store TEMP tables,
> manifested views, automatic indices, and as temporary storage for sorting
> operations and for VACUUM.  Compile with -DSQLITE_TEMP_STORE=3 to disable
> them.  Note, however, that when the etilqs files are disabled, the
> equivalent information is held in RAM instead.

SQLite creates such a file, uses it, then deletes it.  You probably shouldn't 
see more than one of them at any time and you shouldn't see any of them when no 
SQLite programs are running.  Something in your system is stopping them from 
being deleted correctly.

The problem is probably caused by an anti-virus program you have installed.  If 
it's scanning the file when SQLite tries to delete it, it will stop the file 
being deleted.  The other possibility is that a SQLite-using program has enough 
rights to create a new file in that folder, but not to delete the file it 
created.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Use of etilqs-files

[Richard Hipp]

On Wed, Sep 10, 2014 at 4:50 AM, Dileep  wrote:

> Hi,
>
> What is the use etilqs-files. Is there any way I can disable my application
> creating these temp files in the native temp directory ? Is there any issue
> on disabling these temp files also ?
>
>

See http://www.sqlite.org/tempfiles.html

The etilqs files are used (on Windows only) to store TEMP tables,
manifested views, automatic indices, and as temporary storage for sorting
operations and for VACUUM.  Compile with -DSQLITE_TEMP_STORE=3 to disable
them.  Note, however, that when the etilqs files are disabled, the
equivalent information is held in RAM instead.

-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Use of etilqs-files

[Dileep]

Hi,

What is the use etilqs-files. Is there any way I can disable my application
creating these temp files in the native temp directory ? Is there any issue
on disabling these temp files also ?

-- 
  Regards
  D.S. DIleep
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users