If you are using native IBO you can have them simply prepared and then do
inserts without opening and fetching records.
With the TDataset based components you have to open the query which will
fetch records before you can insert.

Do transactions depending on how you consider a batch of work a single unit
of work. Also take user update conflict into consideration.

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

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: "wayne" <waynef@...>
To: <IBObjects@yahoogroups.com>
Sent: Sunday, December 15, 2002 2:26 AM
Subject: [IBO] open datasets for inserting taking long.


> I have about 5 datasets ,, I have to open when a form becomes visual,
>
> I want to open the datasets for inserting Data.
>
> I have noticed that when I open the DataSets it takes rather long since
> the first Record of each dataset gets displayed for a brief second or two.
>
> My Question is , how can I put the datasets into insert mode without data
> running up and
> down the wire ,, or at least minimal ?
>
>
> Or should I keep the DataSets open throuhout my apllication ?
>
> If so here is my initial thought ::
> If so How Does one acomplish this in an MDI application.
> " Have one central DataModule for Datasets" and
> "a TRanSaction pertaining to each Form instance".