Hello sqlite Users,

I am using sqlite on arm-board and getting a "database or disk full" error
(SQLITE_FULL) while using the  update command.

1. DB file location is set to some /opt/dbspace/*.db. ( 32 Gb space and 4
GB RAM)

2. Not used compile time option  SQLITE_TEMP_STORE so, deafult value 1.
3. I have used pragma journal_mode=WAL.
4. No pragma temp_store.

Please help me with below queries

a) where is the temporary files location ?? How is it determined if i dont
give any storage settings.
b)  Do i need to set TMPDIR env variable to give another location for
temporary files or temp_store_directory ?
c) If i set another location for temporary files, how does the performance
gets affected ?

Thanks in advance

regards,
Jitendar
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to