Allan, Mark schrieb:
RB Smissaert,
The database file is named <thename>.vdb. Is .vdb ok or wrong? Does it have to
be .db3? Or is there just certian extensions I need to avoid?
I quote from http://www.sqlite.org/cvstrac/wiki?p=PerformanceTuningWindows
"Be *VERY, VERY* careful what you name your database, especially the
/extension/
For example, if you give all your databases the extension .sdb (SQLite
Database, nice name hey? I thought so when I choose it anyway...) you
discover that the SDB extension is already associated with APPFIX PACKAGES.
Now, here is the cute part, APPFIX is an executable/package that Windows
XP recognizes, and it will, (emphasis mine) *ADD THE DATABASE TO THE
SYSTEM RESTORE FUNCTIONALITY*
This means, stay with me here, every time you write ANYTHING to the
database, the Windows XP system thinks a bloody executable has changed
and copies your ENTIRE 800 meg database to the system restore directory....
I recommend something like DB or DAT.
The entire list of system restore-monitored filename extensions can be
found at:
ยคhttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/sr/sr/monitored_file_extensions.asp";
<http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sr/sr/monitored_file_extensions.asp>
Dr Hipp,
Nice to see that i am not the only one you read drh as Dr. H. ;-) in
fact his name is D. Richard Hipp.
But i have never seen before the habit to abreviate the first surname.
Regards,
Gunnar
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
