Maybe set the SchemaCachedir-property in connectioncomponent?

John


John Costanzo wrote:

> 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?
>
> Thanks
>
>
> --- In IBObjects@yahoogroups.com, 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
>
> 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.
>>
>>What's the suffix of your database file? If ".gdb" then change it
>
> to
>
>>".ib" or ".fdb" because you are encountering a well-known issue
>
> with
>
>>XP's SystemRestore feature - it locks a ".gdb" file as soon as it
>
> is
>
>>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
>>
>
>
>
>
>
>
>
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>

--
John vd Waeter
mailto:john@...
http://www.jvdw.nl
http://www.shotinthedark.nl