Subject Long delay when 1st connecting to database
Author John Costanzo
I am trying to convert some Paradox applications to IBO. All works
great except that the 1st time I connect to the database there is a
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 but
the same delay. This only happens the 1st time the database is
connected. If I exit the application and restart it all works fine
but if I turn the system of and on and then restart the application
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. Can
anyone assist.