> > > > > Firebird 1.03 has the same problem with Server 2003 as Interbase 6.
> The
> > > > > problem being that it is very sloooooow. It does however function.
> > > > >
> > > >
> > > > Out of interest - why is it slow?
> > >
> > > Mainly connect/disconnect is extremly slow. The following is a result
> > > of an ongoing discussion in a German newsgroup.
> > >
> > > InterBase 6 and Firebird seem to work well on Windows 2003 when you
> > > optimize the processor and memory to *Programs* and when you disable
> > > the new "Shadow Copy Volumes" (it's a new feature in Windows 2003)
> > > feature for the partitions, where the database files are stored.
> > > http://www.techexams.net/technotes/70292/shadowcopies.shtml
> > >
> > > Again, Firebird 1.5 works well under Windows 2003 without these
> > > tweaks.
> >
> > Thomas -- do these tweaks fix the excruciating connect time problem or just
> > make Interbase and Firebird perofrm better after the connection is made ?
>
> Yes, the connect is getting back to normal when you switch
> the optimization to Program. Though, I would recommend that
> you give it a try as well, to be sure, that it works in
> your environment too. Be aware that I don't know if that
> setting will have an negative impact on any other programs
> or services installed. Give it a try or switch to Firebird 1.5

My fault -- I did try it and the problem has persisted. I've seen various other
mention of fixes for this, 'turn off hyperthreading', 'add terminal services
application mode', etc. and none of them have worked. This is our first 2003
customer so I do not have another one to try these fixes on.

I'm bummed and my concerns for us using FireBird are this:

* Porting -- we have to port better than a bit of code. Firebird's better
compliance with standards got us!

* Drivers -- we use BDE now. Hate it, but we are stuck with D5 for awhile. What
is the safest, easiest combination of drivers, techniques to use to access
FB1.5 when it arrives via BDE? We'd very much like to change one thing at a
time, i.e. change DB servers first, then migrate to BDE alternative.

Is there a recommended, 'best' option for converting FB1.5 Server with minimal
changes to our BDE based code?

Thanks,
Kevin