Subject Re: [firebird-support] parrallel update
Author Ann Harrison
Stephane,

>
> I want to do simultaneous these update :
>
> Update table1 ...
> Update table2 ...
> etc...
> Update tablen ...
>
> the table1, table2, ... tableN are not connected in any way
>
> now i can do these update in parallel using n connections, but
> i would to avoid using n connection (mean start n transaction, etc...)

Sorry for the dumb question, but why do you want to do those
operations in parallel? The SuperServer runs only one thread at a
time, ties a connection to an thread, and uses only one processor. Do
you think it will be faster interweaving n commands than running the
operations sequentially? And of course, the classic architecture has
the same general limitations, except there is a process per
connection.

>
> is their any way to execute theses n update in parallele inside one
> connection and one transaction ?

No.

Good luck,

Ann