Subject | Re: Which way is best... |
---|---|
Author | Michael Vilhelmsen |
Post date | 2005-11-11T11:31:46Z |
Ok.
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.
Michael
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.
Michael