RE: Perl Issues
- From: "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
- To: JApplewhite@xxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Fri, 22 Feb 2008 10:26:04 -0500
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@xxxxxxxxxxxxxxxxx
www.credit-suisse.com
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
JApplewhite@xxxxxxxxxxxxx
Sent: Thursday, February 21, 2008 4:26 PM
To: oracle-l@xxxxxxxxxxxxx
Cc: oracle-l-bounce@xxxxxxxxxxxxx
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
==============================================================================
Other related posts:
