RE: Ant Sql task slow

2006-07-12 Thread eastwoj
that's good to know ..adds to the mystery though. Its a 1.8Ghz processor; 1.00GB RAM -- but the same behavior is witnessed on several machines. I ended up replacing the task with an which runs sqlplus directly to load and execute the statements in the file .. i'm not entirely happy with tha

RE: Ant Sql task slow

2006-07-12 Thread eastwoj
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.co

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] Fo

Ant Sql task slow

2006-07-12 Thread eastwoj
I'm trying to execute a sql file using Ant's sql task via a Maven goal. The goal passes a file of insert statements to the Ant sql task. When I run the insert statements in the file in sqlplus, they run in a few minutes. Running them via the ant task, though .. takes upwards of 15 mins .. a con