MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: Question about the Query Cache and server settings
Posted by: Andrew Gilfrin
Date: July 23, 2005 12:14AM

Jay,

Whats the effect of using prepared statements in PHP with regards to the query cache?

Is it the same as say Oracle where prepared statements in the application are the be all an end all when it comes to scalabilty in code (ask Tom Kyte) or is it just a nice way to format your statement in PHP.

I'd assume the former but don't know enough about the internals of MySQL.

Prepared statements are available in the mysqli php library and not mysql.

Regards

Andrew Gilfrin
------------------
http://gilfster.blogspot.com
My MySQL related Blog

http://www.mysqldevelopment.com
MySQL Stored Procedure,Trigger, View.... (Just about most things these days) Information

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Question about the Query Cache and server settings
2460
Erin ONeill
July 22, 2005 04:28PM
Re: Question about the Query Cache and server settings
4011
Jay Pipes
July 22, 2005 05:40PM
Re: Question about the Query Cache and server settings
1665
Andrew Gilfrin
July 23, 2005 12:14AM
Re: Question about the Query Cache and server settings
1750
Jay Pipes
July 24, 2005 09:56AM
Re: Question about the Query Cache and server settings
1505
Roland Bouman
July 24, 2005 12:46PM
Re: Question about the Query Cache and server settings
1662
Jay Pipes
July 24, 2005 04:56PM
Re: Question about the Query Cache and server settings
1726
Erin ONeill
July 25, 2005 10:47AM
Re: Question about the Query Cache and server settings
1858
Jay Pipes
July 25, 2005 06:56PM
Re: Question about the Query Cache and server settings
1816
Erin ONeill
July 26, 2005 12:36PM
Re: Question about the Query Cache and server settings
1732
Jay Pipes
July 26, 2005 08:23PM
Re: Question about the Query Cache and server settings
1619
Erin ONeill
July 26, 2005 10:53PM
Re: Question about the Query Cache and server settings
1939
Erin ONeill
July 27, 2005 10:23AM
Re: Question about the Query Cache and server settings
1691
Jay Pipes
July 30, 2005 12:07PM
Re: Question about the Query Cache and server settings
1631
Erin ONeill
July 30, 2005 05:17PM
Re: Question about the Query Cache and server settings
1614
Erin ONeill
July 27, 2005 10:28AM
Re: Question about the Query Cache and server settings
1652
Erin ONeill
July 26, 2005 12:45PM
Re: Question about the Query Cache and server settings
1769
Jay Pipes
July 26, 2005 08:45PM
Re: Question about the Query Cache and server settings
1742
Erin ONeill
July 26, 2005 10:59PM
Re: Question about the Query Cache and server settings
1791
Erin ONeill
July 25, 2005 04:30PM
Re: Question about the Query Cache and server settings
1671
Jay Pipes
July 25, 2005 07:01PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.