sorry to do this but need to make sure my out of office response isint going
to spam you guys.

Robert W. Collins II
New Orleans Regional Transit Authority
Phone : (504) 248-3826
Fax: (504) 248-3866

-----Original Message-----
From: Alberto Serra [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 12, 2002 11:25 AM
Subject: Re: [PHP] PHP and ORACLE


I hope you are not really living in the early 70's, are you?

Ricardo Fitzgerald wrote:
> Hi,
> I started with PHP and MYSQL a while ago and now I've been involved in
> a huge database project with ORACLE. 

Have the Oracle box do most of it. Make sure that:
1) there is  a well defined API for external application (including your
PHP client) to access data. This *must* written an paper and documented.
No code writing prior to this.
2) all about referential integrity is done within Oracle
3) use triggers and SPs to enforce data consistency (handle with care, 
they load the db server if used unproperly)
4) find a good DBA to maintain the system (Oracle can degrade quite 
dramatically if not properly maintained)
5) interact very little with the DB, to avoid loading its server. (That 
is, call an SP, get the result set from a tmp table)
6) avoid locking as much as you can
7) Prey the current Oracle bugs are not too evil.
8) get ready to say good bye to your vacations.
9) ask for a paycheck raise



LoRd, CaN yOu HeAr Me, LiKe I'm HeArInG yOu?
lOrD i'M sHiNiNg...
YoU kNoW I AlMoSt LoSt My MiNd, BuT nOw I'm HoMe AnD fReE
tHe TeSt, YeS iT iS
ThE tEsT, yEs It Is
tHe TeSt, YeS iT iS
ThE tEsT, yEs It Is.......

PHP General Mailing List (
To unsubscribe, visit:

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to