Mailing-List: contact user-help@ant.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Ant Users List" <user@ant.apache.org>
Received-SPF: pass (asf.osuosl.org: local policy)
Content-class: urn:content-classes:message
MIME-Version: 1.0
Subject: RE: Ant Sql task slow
Date: Wed, 12 Jul 2006 13:57:02 -0700
Message-ID: <200607122101.k6CL14BO027885@barriere241.nike.com>
In-Reply-To: <5295331.post@talk.nabble.com>
Thread-Topic: Ant Sql task slow
Thread-Index: Acal5ibjQY4TgSUBTKqdKSDuaRjXigADZdqQ
From: "Anderson, Rob (Global Trade)" <Rob.Anderson@nike.com>
To: "Ant Users List" <user@ant.apache.org>
Content-Type: text/plain;
 charset=us-ascii
Content-Transfer-Encoding: quoted-printable

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:jeastwood@fastmail.fm]=20
> Sent: Wednesday, July 12, 2006 12:02 PM
> To: user@ant.apache.org
> Subject: RE: Ant Sql task slow
>=20
>=20
> yes. same machine .. i'm wondering if the problem might be=20
> something to do with the fact that Ant is using JDBC to=20
> execute the statements while sqlplus uses sqlnet.  Maybe ant=20
> is reading all 23000 statements into memory and that's a problem?=20
> --
> View this message in context:=20
> http://www.nabble.com/Ant-Sql-task-slow-tf1932043.html#a5295331
> Sent from the Ant - Users forum at Nabble.com.
>=20
>=20
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
> For additional commands, e-mail: user-help@ant.apache.org
>=20
>=20
>=20


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org