Is Perl-DBI Slow?

I've heard that perl-DBI is slow. Is this true? If so, is it because of
Perl being an interpreted language?

RE: Is Perl-DBI Slow?

No true. The DBD::Oracle module essentially is a Pro*C "wrapper" around
your Perl code.

You network might be slow, or your database instance might be badly
configured, or you application design might be bad, or you might write
bad queries. This could make it appear that Perl is slow. Do not be
deceived, Perl is fast.

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-----Original Message-----
From: LLC [mailto:kevin@kevinkempterllc.com]=20
Sent: Wednesday, June 14, 2006 11:12 AM
To: dbi-users@perl.org
Subject: Is Perl-DBI Slow?

I've heard that perl-DBI is slow. Is this true? If so, is it because of
Perl being an interpreted language?


This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
or use of the contents of this information is prohibited. Please notify =
the
sender of the delivery error by replying to this message, or notify us =
by
telephone (877-633-2436, ext. 0), and then delete it from your system.

Re: Is Perl-DBI Slow?

compare for yourself

http://www.xs4all.nl/~hmbrand/dpws2006/prfo.html

----- Original Message -----
From: "Reidy, Ron"
To: ;
Sent: Wednesday, June 14, 2006 1:17 PM
Subject: RE: Is Perl-DBI Slow?


No true. The DBD::Oracle module essentially is a Pro*C "wrapper" around
your Perl code.

You network might be slow, or your database instance might be badly
configured, or you application design might be bad, or you might write
bad queries. This could make it appear that Perl is slow. Do not be
deceived, Perl is fast.

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-----Original Message-----
From: LLC [mailto:kevin@kevinkempterllc.com]
Sent: Wednesday, June 14, 2006 11:12 AM
To: dbi-users@perl.org
Subject: Is Perl-DBI Slow?

I've heard that perl-DBI is slow. Is this true? If so, is it because of
Perl being an interpreted language?


This electronic message transmission is a PRIVATE communication which
contains
information which may be confidential or privileged. The information is
intended
to be for the use of the individual or entity named above. If you are not
the
intended recipient, please be aware that any disclosure, copying,
distribution
or use of the contents of this information is prohibited. Please notify the
sender of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: Is Perl-DBI Slow?

I find Perl with DBI to be very fast, which is one of the main reasons I
use it.

I've seen database update code written another way that is very slow:
namely, to write shell scripts and repeatedly invoke the command-line
tool (e.g. dbaccess in the case of Informix).

Perl DBI is several orders of magnitude faster than the shell approach
for a number of reasons. (A) Perl is faster because it is compiled
(*). (B) Fixed socket connection to the DB is much more efficient than
repeatedly loading the command-line tool. (C) Data structure
capabilities in Perl mean more data can be cached and you don't need to
keep hitting the disk.

Perl is nearly as fast as embedded C code but not quite. As someone
else mentioned, bulk load operations written in C can beat Perl.
However for general mixed database work you get a lot of flexibility
without much performance hit.

(*) I notice you said Perl is interpreted. This is not true. Perl
uses compile-on-load. It compiles to a virtual machine, just as Java
does, and therefore is not quite as fast as a native code compiler, but
a lot faster than interpreted code.

-Will


> -----Original Message-----
> From: LLC [mailto:kevin@kevinkempterllc.com]=20
> Sent: Wednesday 14 June 2006 13:12
> To: dbi-users@perl.org
> Subject: Is Perl-DBI Slow?
>=20
>=20
> I've heard that perl-DBI is slow. Is this true? If so, is it=20
> because of
> Perl being an interpreted language?
>=20
>=20


- - - - - Appended by Scientific Atlanta, a Cisco company - - - - -=20
This e-mail and any attachments may contain information which is confidenti=
al, proprietary, privileged or otherwise protected by law. The information =
is solely intended for the named addressee (or a person responsible for del=
ivering it to the addressee). If you are not the intended recipient of this=
message, you are not authorized to read, print, retain, copy or disseminat=
e this message or any part of it. If you have received this e-mail in error=
, please notify the sender immediately by return e-mail and delete it from =
your computer.

Re: Is Perl-DBI Slow?

-- LLC

> I've heard that perl-DBI is slow. Is this true? If so, is it because of
> Perl being an interpreted language?

Perl is compiled, always has been.

DBI is no slower than any other application that has to
talk to a database. This involves disk and/or network I/O,
transaction processing, and any latency involved in using
a time-shared system (just about all of them these days).

I have worked on large datasets with Perl using DBI for
years; in most cases my Perl runs no slower than C that
"real" programmers come up with and frequently runs faster.


--
Steven Lembark 85-09 90th Street
Workhorse Computing Woodhaven, NY 11421
lembark@wrkhors.com 1 888 359 3508