Re: MySQL- Stored Procedures & Views

Re: MySQL- Stored Procedures & Views

am 31.08.2006 06:16:44 von Haydar TUNA

------=_NextPart_000_001F_01C6CCCD.6B2CD4E0
Content-Type: text/plain;
charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable

Hello,
Stored Procedures are faster than standart sql query beacuse =
they have already compiled sql script.


--=20
Republic Of Turkey - Ministry of National Education
Education Technology Department Ankara / TURKEY
Web: http://www.haydartuna.net=20
""Lasitha Alawatta"" , haber iletisinde sunlari =
yazdi:6E7274B65DE08549A4F44A97C73791FB0A17ADCE@DOTWSEXH01.do tw.ae...
Hi All,=20

=20

Any body has experience using MySQL Stored Procedures & Views with =
PHP.=20

How is the performance of using SPs in mysql.=20

=20

=20

=20

Lasitha Alawatta

Application Developer

Destinations of the World Holding Establishment

P O Box: 19950

Dubai, United Arab Emirates

=20




DOTW DISCLAIMER:

This e-mail and any attachments are strictly confidential and =
intended for the addressee only. If you are not the named addressee you =
must not disclose, copy or take
any action in reliance of this transmission and you should =
notify us as soon as possible. If you have received it in error, please =
contact the message sender immediately.
This e-mail and any attachments are believed to be free from =
viruses but it is your responsibility to carry out all necessary virus =
checks and DOTW accepts no liability
in connection therewith.=20

This e-mail and all other electronic (including voice) =
communications from the sender's company are for informational purposes =
only. No such communication is intended
by the sender to constitute either an electronic record or an =
electronic signature or to constitute any agreement by the sender to =
conduct a transaction by electronic means.
=20

------=_NextPart_000_001F_01C6CCCD.6B2CD4E0--

[PHP-INSTALL] MySQL- Stored Procedures & Views

am 22.08.2007 08:27:27 von Lasitha Alawatta

This is a multi-part message in MIME format.

------=_NextPartTM-000-cc9da068-11fa-4776-a049-c36d319e149f
Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01C7E485.84857341"

------_=_NextPart_001_01C7E485.84857341
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi All, Any body has experience using MySQL St=
ored Procedures & Views with PHP. =0AHow is the performance of u=
sing SPs in mysql. =0D=
=0ALasitha Alawatta Application Developer Destination=
s of the World Holding Establishment P O Box: 19950 D=
ubai, United Arab Emirates =0ADOTW DISCLAIMER: =0D=
=0AThis e-mail and any attachments are strictly confidential and intended f=
or the addressee only. If you are not the named addressee you must not disc=
lose, copy or take any action in reliance of this transmission and you=
should notify us as soon as possible. If you have received it in error, pl=
ease contact the message sender immediately. This e-mail and any attac=
hments are believed to be free from viruses but it is your responsibility t=
o carry out all necessary virus checks and DOTW accepts no liability i=
n connection therewith. =0AThis e-mail and all other electronic =
(including voice) communications from the sender's company are for informat=
ional purposes only. No such communication is intended by the sender =
to constitute either an electronic record or an electronic signature or to =
constitute any agreement by the sender to conduct a transaction by electron=
ic means.
------_=_NextPart_001_01C7E485.84857341
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

hemas-microsoft-com:office:word" xmlns:st1=3D"urn:schemas-microsoft-com:off=
ice:smarttags" xmlns=3D"http://www.w3.org/TR/REC-html40"> =0D=
=0A ii"> ium)"> e:smarttags" name=3D"place"/> n:schemas-microsoft-com:office:smarttags" name=3D"country-region"/>=0D=
=0A gs" name=3D"City"/> microsoft-com:office:smarttags" name=3D"PersonName"/> =
=

Arial>Hi All, >

ce=3DArial>&n=
bsp;

face=3DArial>Any =
body has experience using MySQL Stored Procedures & Views with PHP=

e=3D2 face=3DArial> >How is the performance of using SPs in mysql. >

'font-size:10.0pt; font-family:Arial'> <=
/p>

=3D'font-size:10.0pt; font-family:Arial'>  t>

yle=3D'font-size:10.0pt; font-family:Arial'>  font>

ont size=3D1 color=3Dgray face=3DTahoma> t;font-family:Tahoma;color:gray; font-weight:bold'>Lasitha Alawatta span> or:gray'>

<=
font size=3D1 color=3Dgray face=3DTahoma> t;font-family:Tahoma;color:gray;font-weight:bold'>Applicatio n Develope=
r
le=3D'font-size:8.0pt;font-family:Tahoma;color:gray'> nt>

ce=3DTahoma> lver;font-weight:bold'>Destinations of the World Holding Establishment=
yle=3D'font-size:7.0pt;font-family:Tahoma;color:silver'><=
/font>

face=3DTahoma> :silver;font-weight:bold'>P O Box: 19950 1 color=3Dsilver face=3DTahoma> ily:Tahoma;color:silver'>

MsoNormal> =0A color=3Dsilver face=3DTahoma> y:Tahoma; color:silver;font-weight:bold'>Dubai 1:City> font-size:7.0pt;font-family:Tahoma; color:silver;font-weight:bold'>, =
United Arab Emirates gion>
Tahoma> '>

3 face=3D"Times New Roman">&nbs=
p;



lor=3Dwhite style=3D"color:black">

DOTW DISCLAIMER:
=

This e-mail and any attachments are =
;strictly confidential and intended for the a=
ddressee only. If you are not the named&=
nbsp;addressee you must not disclose, copy or=
 take
any action in reliance of this=
 transmission and you should notify us a=
s soon as possible. If you have received=
 it in error, please contact the message=
 sender immediately.
This e-mail and any&=
nbsp;attachments are believed to be free from=
 viruses but it is your responsibility t=
o carry out all necessary virus checks a=
nd DOTW accepts no liability
in connectio=
n therewith. 

This e-mail and a=
ll other electronic (including voice) communicatio=
ns from the sender's company are for =
;informational purposes only.  No such commun=
ication is intended
by the sender to =
;constitute either an electronic record or an=
 electronic signature or to constitute any&nb=
sp;agreement by the sender to conduct a =
transaction by electronic means.
=

------_=_NextPart_001_01C7E485.84857341--


------=_NextPartTM-000-cc9da068-11fa-4776-a049-c36d319e149f- -

Re: Re: MySQL- Stored Procedures & Views

am 31.08.2007 07:19:39 von dmagick

Haydar TUNA wrote:
> Hello,
> Stored Procedures are faster than standart sql query beacuse they have already compiled sql script.

I wouldn't say that's the case every single time - personally I'd do
some testing to see what works better.

--
Postgresql & php tutorials
http://www.designmagick.com/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php