如何更改 sqlite 创建 etilqs 文件的临时文件夹? [英] How can I change the temp folder where sqlite creates etilqs files?

问题描述

(这个问题是 如何避免 httpd.exe 在 C\WINDOWS\TEMP\ 中创建 etilqs?)

我的计算机上安装了 Apache 2.4，并且使用了 localhost Web 应用程序.

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

这个应用程序使用了一个 sqlite 数据库(通过 PHP PDO)，它在开始时很小，但现在它有 66518 行.

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

COMODO 防火墙的 Defense+ 模块警告我 http.exe 想要创建新文件/文件夹 C:\WINDOWS\TEMP\etilqs_???，在哪里???是随机数字和字母.

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 显示警告，因为 C:\WINDOWS 是受保护的文件夹.然后，也许我可以更改文件夹，以便 sqlite 将这些文件存储在不受保护的文件中，以避免出现警告.

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.

推荐答案

要更改临时目录，请更改 TEMP 和 TMP 环境变量的值.

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

根据您的 Windows 版本，您可能会在计算机 ➝ 属性 ➝ 高级 ➝ 环境变量下找到它们.

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

这篇关于如何更改 sqlite 创建 etilqs 文件的临时文件夹?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！