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
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
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
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
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
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
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 file using Ant's sql task via a
> Ma
