RE: Perl Issues
Date: Fri, 22 Feb 2008 10:26:04 -0500
Message-ID: <21469B88E0EA11498818517F2103353101C65F7C@EPRI17P32001A.csfb.cs-group.com>
150,000 tables? Good grief! I admit that I know nothing about student
information applications, but that seems like an awful lot of tables.
Why so many?
Paul Baumgartel
CREDIT SUISSE
Information Technology
Prime Services Databases Americas
One Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel_at_credit-suisse.com
www.credit-suisse.com
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
JApplewhite_at_austinisd.org
Sent: Thursday, February 21, 2008 4:26 PM
To: oracle-l_at_freelists.org
Cc: oracle-l-bounce_at_freelists.org
Subject: Perl Issues
Our Developers wrote our Special Ed Student Info. application in Perl - about which I know zip. Without going into gory details of why, their code repeatedly checks for the existence of specific tables (out of the 150,000+ tables in our Production Student Info.) by doing "Select Count(*) From All_Tables Where Table_Name = '<TableName>'" whick is very inefficient, especially with 150,000 tables.
First of all, I want them to not check for table existence and code in Exception Handling, but they are resistent to my suggestions.
Second, if they don't code the Exception Handling, I want them to use a utility function that we have that more efficiently checks for table existence and returns a Boolean - True if exists, False if not exists.
My two questions:
1. Can Exception Handling be easily done in Perl? If so, any good
examples I can point them to?
2. They say that Perl can't handle Boolean values. Is that true? Any
guidance here?
Thanks.
Jack C. Applewhite - Database Administrator
Austin I.S.D.
414.9715 (phone) / 935.5929 (pager)
Please access the attached hyperlink for an important electronic communications disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 22 2008 - 09:26:04 CST