>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/comp
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
>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 coul
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?
>
> Wel
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]>
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 th
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 th
7 matches
Mail list logo
