On Sat, 06 Jul 2002 15:27:47 -0500
Do you have *ANY* idea how quickly:
select * from MyTable can be parsed and an execution plan selected?!
It's CHUMP CHANGE in time.
*ONLY* if your SQL is so incredibly complicated that you can't even
understand it will the parse/compile time of SQL be
On Sat, 06 Jul 2002 01:16:28 -0500
Richard Lynch [EMAIL PROTECTED] wrote:
I'm using a postgres datbase for my PHP project, how do I make stored
procedures? Or if no SPs then what would be recomendation for building
simple/reuseable Put and Get procedures for my data?
Well, if nothing
Stored procedures are like any other type of programming construct.
You can do them right or you can do them wrong.
Yeah, and GOTO is perfectly fine... In the right place.
When making a stored
procedure you should stick to ansi SQL as much as possible.
All my SQL was so dirt-simple, it
On Sat, 06 Jul 2002 15:27:47 -0500
Richard Lynch [EMAIL PROTECTED] wrote:
Do you have *ANY* idea how quickly:
select * from MyTable can be parsed and an execution plan selected?!
It's CHUMP CHANGE in time.
*ONLY* if your SQL is so incredibly complicated that you can't even
understand
Actually,
Postgres supports stored procedures, triggers and views to name a few where
mysql does not...
B i g D o g
- Original Message -
From: Mark McCulligh [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, July 05, 2002 1:45 PM
Subject: [PHP] Re: Stored Procedures
I think
MySQL does in 4.0, but that's in alpha right now.
-Original Message-
Postgres supports stored procedures, triggers and views to name a few where
mysql does not...
This message is intended for the sole use of
Sorry, didn't think they did.
Does someone have an example, I have never seen one.
--
_
Mark McCulligh, Application Developer / Analyst
Sykes Canada Corporation www.SykesCanada.com
(888)225-6824 ex. 3262
[EMAIL PROTECTED]
B I G D O G [EMAIL PROTECTED]
7 matches
Mail list logo