RE: Perl Issues
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?
Prime Services Databases Americas
One Madison Avenue
New York, NY 10010
[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
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?
Jack C. Applewhite - Database Administrator
414.9715 (phone) / 935.5929 (pager)
Please access the attached hyperlink for an important electronic communications disclaimer:
Received on Fri Feb 22 2008 - 09:26:04 CST