On Sat, Jun 18, 2011 at 17:30, Bert Huijben <b...@qqmail.nl> 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