我如何可以改变sqlite的创建etilqs文件的临时文件夹? [英] How can I change the temp folder where sqlite creates etilqs files?
问题描述
(这个问题的<一个分拆href=\"http://stackoverflow.com/questions/16121290/how-to-avoid-httpd-exe-from-creating-etilqs-in-c-windows-temp/16121977#16121977\">How为了避免httpd.exe从创建用C \\ WINDOWS \\ TEMP \\?)etilqs
(This question is a spin-off of How to avoid httpd.exe from creating etilqs in C\WINDOWS\TEMP\?)
我的Apache 2.4安装在我的电脑和我用本地主机的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.
有一段时间,当我运行
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防火墙的防御+模块警告我说, 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防火墙给出了警告,因为 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屋!