[EMAIL PROTECTED] wrote:
2. On Windows, generally speaking, it's not allowed to rename a file if it is currently opened. This will cause database compact to fail;
By "generally speaking", you mean "unless you open the file with the appropriate flags." In particular, setting the FILE_DELETE_SHARE flag in the CreateFile call will give you UNIX-like semantics on the file name. It's probably a good idea to read the other flags and pick the appropriate ones to set, testing performance afterwards. It can make a fairly big difference, with things like non-cached read-ahead if you're scanning through an entire file building a new one, for example.
http://msdn.microsoft.com/en-us/library/aa363858(VS.85).aspx HTH. -- Darren New / San Diego, CA, USA (PST) Helpful housekeeping hints: Check your feather pillows for holes before putting them in the washing machine.
