692408 - Investigate possible SQlite Win vfs that would let us rename database files while they are used

Status: RESOLVED WONTFIX

(Core :: SQLite and Embedded Database Bindings, defect)

Description

[David Teller [:Yoric] - still alive but not very active]

For performance reasons, we are attempting to get rid of as many SQlite file I/O as possible, and in particular, we are investigating replacing some SQlite transactions by filesystem based transactions (see bug 691268).

Unfortunately, at the moment, the mechanism detailed in that bug cannot work under Windows, as it requires renaming a file while it is open, while the win32 vfs of SQlite opens files in a non-renaming mode (see file sqlite3.c, line 28478).

With SQlite's vfs mechanism, we can certainly provide a new vfs (let's call it "win32moz"), based on the win32 vfs, replacing only file winOpen by something near identical but that adds the FILE_SHARE_DELETE.

If we decide to use this approach, remains the question of how to use this vfs: should we register win32moz as the default win32 vfs?

Comment 1

[David Teller [:Yoric] - still alive but not very active]

Since bug 691268 is WONTFIX, doing the same here.