Subject | Long delay when 1st connecting to database |
---|---|
Author | John Costanzo |
Post date | 2006-08-14T13:15:19Z |
Hello:
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.
Thanks
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.
Thanks