|Subject||Re: [firebird-support] Re: Which way is best...|
> Either way could be implemented.How long does it take?
> 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 )
> 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.
Is this a one time operation? If so, and it takes little time, why bother?
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Database development questions? Check the forum!