I think if one has privileges to create stored procedure, he can create one to execute the whole batch of sql as a single call. The sql insert may not execute any faster but the network overhead could be much reduced. But apparently you do not have direct connection to sqlsvr.
Втр, 22 Июн 2010, Alex Rufon писал(а): > This is what I normally do. I mean I create huge SQL files with a thousands > of rows of SQL Insert statements from J and submit this file to our backend > service for insertion. > > I basically split the operation in parts: > 1. SQL DML command generation. [J] > 2. Transmit data to the server (Sockets, email, ftp, etc). [C#] > 3. SQL execution on the local database server. [DB Local/Builtin facility] > > I'm just suggesting that maybe you can look at alternative ways of getting > your data into the server. > > -----Original Message----- > [---=| TOFU protection by t-prot: 21 lines snipped |=---] -- regards, ==================================================== GPG key 1024D/4434BAB3 2008-08-24 gpg --keyserver subkeys.pgp.net --recv-keys 4434BAB3 ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
