4

(This question is a spin-off of How to avoid httpd.exe from creating etilqs in C\WINDOWS\TEMP\?)

I have Apache 2.4 installed in my computer and I use a localhost web application.

This application uses a sqlite database (through PHP PDO), which was small at the beginning but now it has 66518 rows.

For a while, when I run

SELECT Z.A,B,C,D,(SELECT 1 FROM X WHERE X.A=Z.A AND X.E IS NOT NULL)
FROM Y,Z
Where F=:f AND Y.A=Z.A
ORDER BY D IS NULL DESC, D IS "" ASC, D DESC
LIMIT :startRow,24

the COMODO Firewall's Defense+ Module warns me that http.exe wants to create the new file/folder C:\WINDOWS\TEMP\etilqs_???, where ??? are random numbers and letters.

I think that it happens because the database has became big (at the beginning I didn't have this problem).

COMODO Firewall shows the warning because C:\WINDOWS is a protected folder. Then, maybe I could change the folder so that sqlite stores these files in an unprotected one to avoid the warnings.

CL.
  • 173,858
  • 17
  • 217
  • 259
Oriol
  • 274,082
  • 63
  • 437
  • 513

1 Answers1

4

To change the temp directory, change the value of the TEMP and TMP environment variables.

Depending on your Windows version, you are likely to find them under Computer ➝ Properties ➝ Advanced ➝ Environment Variables.

CL.
  • 173,858
  • 17
  • 217
  • 259
  • Ah, thanks, I already knew these environment variables but I didn't realize that sqlite is using them – Oriol Apr 20 '13 at 18:45
  • It didn't work me somehow. The C drive is low on memory, but I couldn't get SQLite to store it's temp files on my D drive even though I changed environment variables. Am I missing something? – Hoven Sep 22 '14 at 04:59
  • 1
    Environment variables are a per-process setting. You must restart the program using SQLite (and probably the program you're using to start that program). – CL. Sep 22 '14 at 06:44