On Wed, 10 Apr 2013 08:24:42 +0000, Bernardino Flores/Jeanologia <[email protected]> wrote:
> Any idea about what is happening? Three causes come to mind: 1) Is your database in a system-protected directory, like "C:\Program Files" or "C:\Program Files(x86)"? If so, Windows virtualizes the file and works on a system-provided copy somewhere in C:\Users\%username%\Appdata . Non-static data files do not belong in a program directory. 2) If you only copy the database file, but an "hot" journal is also present-but-not-copied, you corrupt your database. http://sqlite.org/lockingv3.html#how_to_corrupt 3) On some versions of MS Windows, .db is a special extension, which gets a special treatment and should be avoided. Some people reported bad performance if that extension is used, which improves when replaced by something like .sqlite or .etilqs . -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
