At 04:10 PM 09-03-02 +0000, you wrote:

>Hi,
>i need to speed-up a very long data-import operation.
>
>For do my data import i have a specific application written in
>C++Builder and IBO.
>
>When this application work no other user are connected to the
>database and if i can set Forced Writes = false i can speed-up the
>entire process (i think).
>
>But for don't forget Forced Write to OFF i prefer control this
>setting directly from my data-import application if it's possible and
>not from a management console.

If you are using IBO, you can set the ForcedWrites property in the
connection object, at connection time, if no other users are connected.

Just watch out, though, there is no mechanism to switch it true again when
the application closes, without the first user specifically re-setting
it. So you will need to take care that your regular applications actually
set the ForcedWrites property to True. If you leave it as Default, the
regular applications will not know when the special app has set FW
false. Only the first to connect will be able to set it; others will get
an error, so you will also need to intercept and silence the error.

Helen

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________