On Sat, Jun 18, 2011 at 17:30, Bert Huijben <[email protected]> wrote: > This assumes creating many tempfiles is cheaper then updating/reading > the db. On Windows that is certainly not the case. > Creating many tempfiles are expensive because APR/Subversion doesn't pass special flag (FILE_ATTRIBUTE_TEMPORARY) to CreateFile Windows API function call. Sqlite uses this flag and performance is much better.
-- Ivan Zhakov
