Subject Re: [firebird-support] Slow writes on Vista
Author Mark Rotteveel
Questions that come to mind are:
In what folder is your database located?
Is indexing enabled on that location?
Did you exclude the fdb extension from indexing?
Is system restore enabled on the drive containing your database?

By default Vista indexes everything(!) which means that on (every) write
to a file, that file is being reindexed. In some cases system restore
will also make backup copies if the a changed file is located in a
system folder (eg Program Files).


cariad_ilmara wrote:
> Hello,
> I develop a desktop application using Firebird embedded and ran into some troubles with Vista.
> Basically everything works. Connection is fast, read performances (loading a 10K record dataset) is fast enough, but write performances are... abysmal compared to 2K/XP.
> Everything seems about 10x slower (database creation went from 3/4s on 2K/XP to about 30s on Vista, ...)
> I've already tried/checked :
> - On a clean computer (no antivirus, virtually nothing installed)
> - Embedded database uses the .fdb extension
> - System restore is off
> - Firebird embedded DLL 2.0.1, 2.0.4, 2.1.0, 2.1.2 snapshot
> The computers I tried it on are reasonably fast, and during thoses operations CPU and HDD are idling.
> I'm running out of ideas, and all my Googling, FAQ reading, ... turn up nothing. I found 1 thread from may 2008 with someone having what seems to be the same problem, but no resolution whatsoever.
> Do you have any hint or thoughts about what might be the problem ?
> Thanks in advance.

Mark Rotteveel