Re: Ant Sql task slow

2006-07-13 Thread Steve Loughran
eastwoj wrote: 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? this is probably way out of ant's no

RE: Ant Sql task slow

2006-07-12 Thread eastwoj
happy with that because its not as elegant .. but the time is down from 15-20 mins to about 4 -- View this message in context: http://www.nabble.com/Ant-Sql-task-slow-tf1932043.html#a5300179 Sent from the Ant - Users forum at

RE: Ant Sql task slow

2006-07-12 Thread Anderson, Rob (Global Trade)
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

RE: Ant Sql task slow

2006-07-12 Thread eastwoj
ext: 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]

RE: Ant Sql task slow

2006-07-12 Thread Anderson, Rob (Global Trade)
12, 2006 10:51 AM > To: user@ant.apache.org > Subject: RE: Ant Sql task slow > > > around 23,000 insert statements .. > -- > View this message in context: > http://www.nabble.com/Ant-Sql-task-slow-tf1932043.html#a5293969 > Sent

RE: Ant Sql task slow

2006-07-12 Thread eastwoj
around 23,000 insert statements .. -- View this message in context: http://www.nabble.com/Ant-Sql-task-slow-tf1932043.html#a5293969 Sent from the Ant - Users forum at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED

RE: Ant Sql task slow

2006-07-12 Thread Anderson, Rob (Global Trade)
How many rows are you inserting? How much data? -Rob A > -Original Message- > From: eastwoj [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 12, 2006 9:39 AM > To: user@ant.apache.org > Subject: Ant Sql task slow > > > I'm trying to execute a sql fi

Ant Sql task slow

2006-07-12 Thread eastwoj
mins .. a considerable time difference. Does anyone have any idea of why I'm getting the slowdown using Ant's sql task ? -- View this message in context: http://www.nabble.com/Ant-Sql-task-slow-tf1932043.html#a5292452 Sent from the Ant - Users