I just looked at the source for the sql task. Ant will read the file line by line and execute the statements sequentially as they appear in the file, without loading the entire file into memory. The sql task will certainly not be as fast as a native application like sqlplus. What are the specs of the machine that you are running this on? CPU speed, memory?
-Rob A > -----Original Message----- > From: eastwoj [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 12, 2006 12:02 PM > To: user@ant.apache.org > Subject: RE: Ant Sql task slow > > > yes. same machine .. i'm wondering if the problem might be > something to do with the fact that Ant is using JDBC to > execute the statements while sqlplus uses sqlnet. Maybe ant > is reading all 23000 statements into memory and that's a problem? > -- > View this message in context: > http://www.nabble.com/Ant-Sql-task-slow-tf1932043.html#a5295331 > Sent from the Ant - Users forum at Nabble.com. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
