> I must insert many rows(e.g. 2.000-5.000) in a table. If I do this with
save
> funktion from torque it is not perfomant.
Is it much worse than plain SQL ? Did you aquire a connection beforehand
and use the same connection for all saves to avoid connection overhead
(think about the transaction type you want when doing this) ?
> Also it doesn`t work with a
> subselect, because the data comes from a other database. Now I had the
idea to
> do this with the BatchExcution of PreparedStatement. Can I do this with
torque?
I would not know how. But plain JDBC is easy in this case, just nmake sure
to use finally blocks to close the jdbc connection. You can use Torque to
do the select on the other database.
Thomas
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
