Hi Stephen

You are a God ! That worked great, the performance beforehand was

AutoCommit
0.4 s

Explicit Transaction
10.9s

After changing to caClose.

Explicit Transaction
0.2s

Wow, its even better than the AutoCommit status. I assume that Auto
commits would probably also have gained a performance boost from this ?

Thanks so much for your wonderful suggestion, I may have never found
this otherwise!


Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com

Wild Software Ltd



Stephen Boyd wrote:

>Then try setting it to caClose. It is possible that a large result set
>is not causing your problem at all. It was just a thought.
>
>
>--- In IBObjects@yahoogroups.com, Robert martin <rob@c...> wrote:
>
>
>>Stephen Boyd wrote:
>>
>>
>>
>>>The property is called CommitAction and if you have it set to
>>>caFetchAll all rows for all open queries will be fetched on commit.
>>>Change CommitAction to caClose or caInvalidateCursor and that won't
>>>happen.
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>I think that caInvalidateCursor is the default, however I tried
>>
>>
>setting
>
>
>>it and still no better.
>>
>>
>>
>
>
>
>
>
>
>
>___________________________________________________________________________
>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
>
>
>
>
>
>
>
>
>
>