Subject Re: [firebird-support] Re: Which way is best...
Author Martijn Tonies
> Either way could be implemented.
> I have tried a stored procedure.
> It work. But I lack response from the server while the rutine runs.
> I havn't tried the
> insert Into table )
> value,
> value)
> Select value, value from table where condition
> And here I will NOT select records I insert.
> But I could also do it with unidirectional set to TRUE.
> This actually completed with no errors.
> But which is best ?
> There will be other clients connected at this point, so the impact
> should be as small as posible to them.

How long does it take?

Is this a one time operation? If so, and it takes little time, why bother?

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Upscene Productions
Database development questions? Check the forum!