Subject Re: [IBO] Long delay when 1st connecting to database
Author John Costanzo
Hello Hellen:

Changing the suffex helped. I changed it to .IB and now instead of
4 minutes it only takes 30 seconds. Howeverm 30 seconds is a long
delay and I suspect many of my cliends will complain. Is there
anything else I can do to spped up connection time?


--- In, Helen Borrie <helebor@...> wrote:
> At 11:15 PM 14/08/2006, you wrote:
> >Hello:
> >I am trying to convert some Paradox applications to IBO. All
> >great except that the 1st time I connect to the database there is
> >long delay (around 4 minutes). The hard disc light flashes
> >continuously. The 1st application I converted has a table with
over 3
> >million records to I thought that was the problem so I converted
> >another applicaion that has a tables with less that 100 records
> >the same delay. This only happens the 1st time the database is
> >connected. If I exit the application and restart it all works
> >but if I turn the system of and on and then restart the
> >the long delay happens.
> >The only thing I cound think of was that all records were being
> >fetched but the queries have AutoFetchAll set to False so I am
lost. I
> >am using IBO4 , P4 @ 2.4Ghz, XP Pro, 250Gb hard drive, Delphi 7.
> >anyone assist.
> What's the suffix of your database file? If ".gdb" then change it
> ".ib" or ".fdb" because you are encountering a well-known issue
> XP's SystemRestore feature - it locks a ".gdb" file as soon as it
> opened and creates a file image of it. (The first connection to a
> database is the one that causes the IB or Firebird Superserver to
> open the file....and XceedinglyPainful to do its stuff...)
> Helen