--- In firebird-support@yahoogroups.com, "Robin Davis" <Ro.Davis@...>
wrote:

>
> > > -----Original Message-----
> > > From: firebird-support@yahoogroups.com
> > > [mailto:firebird-support@yahoogroups.com]On Behalf Of Robin Davis
> > > Sent: Wednesday, 26 April 2006 12:39 AM
> > > To: firebird-support@yahoogroups.com
> > > Subject: [firebird-support] MS Access 2003 and Firebird
> > >
> > >
> > > Hiya,
> > >
> > > My setup is: XP Home (Fat32 file system, pre installed for
> > > some reason!
> > > and 512 MB RAM)
> > > Firebird 2 RC1
> > > MS Access 2003
> > > Lates IBPhoenix ODBC version 2 (Beta)
> > >
> > > Everthing seems to be working fine, except for one strange
> > > event. If I
> > > have the DB open it works just as expected, but should I

accidentally

> > > close the DB and then re-open it virtually immediately,
> > > there's a pause
> > > of up to 5 seconds before a form opens. This doesn;'t happen
> > > when I open
> > > the DB first time so it doesn't feel like a delay in the ODBC
> > > connection. (But what do I know?)

The usual culprits are system restore (gdb file extension) and volume
shadow (win 2003). But you have already discounted these. I wonder if
you have some metadata caching? May want to also try firebird-odbc
list for more specific information. What happens in that 5 seconds
(disk activity, CPU activity, network activity)

Either that, or maybe you have asynchronous writes, and Firebird is
busy flushing it to disk. What server architecture are you using? (ie
Classic or Superserver). Does it occur on Firebird 1.5, if not it may
belong in either the Firebird-devel or respective IBPhoenix lists?

Adam