The table apparently is quite large so calling Append means it needs to find
the end of the buffer and add to it. Instead of Append, use insert and see
if that shapes things up.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Jose Gomez" <desarrollo@...>
Newsgroups: egroups.ibobjects
To: <IBObjects@yahoogroups.com>
Sent: Thursday, November 29, 2001 3:24 PM
Subject: [IBO] Speed


> Hi, I've detected that with an TIBOTable, the Append method takes a long
> time (2 seconds), which is dramatically reduced if the FetchWholeRows is
> 'false'.
>
> Now, the post method is really slow... even with the FetchWholeRows on
> false.
>
> I'm just appending two or three records on one table and 1 on another, no
> datasources attached, no events are defined.
>
> Any ideas?