-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Thu, Jan 25, 2001 at 09:27:40AM -0500, Ted X Wang wrote:
>
>
> Hi,Gurus:
>
> I'm looking for some help to spped up my perl application.
>
> It's a data loading program written in Oraperl, perl5.02.
>
> Each morning, we need to load about 50,000 records into the oracle database.
>
> The problem is that the oraperl have no way ( not to my knowledge) to do
> array processing. so the application does50,000 times sql call to the
> databasen. Each call takes about 60ms, so the whole loading program takes
> about an hour, which is too long.
Sounds like a flaw in your program or your Oracle setup, since I've written
programs that load over 100,000 rows in about 5 minutes. Sample code would be
helpful in figuring out where your problem lies.
On a side note, Oraperl is deprecated; you should be using the standard DBI
interface.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.8
iQA/AwUBOnBz1wOGqGs0PadnEQIlCACfYvtoY2PfAA6kHeYQWkeWLlHssY4AnjpM
bAaxBWwKboCt862kRmlsp9U3
=rby1
-----END PGP SIGNATURE-----
