MySQL Forums
Forum List  »  Stored Procedures

Re: circumventing limitations on the "Liimit" clause
Posted by: Dewey Gaedcke
Date: January 23, 2007 12:49AM

You know, I'd use prepared statements ALL OVER the place if their execution plans were cached. Unfortunately, they are not and they run MUCH slower than than the equivalent textual query in a stored procedure. I find this interesting since textual queries don't (yet) have their plans cached either. The docs say that Prepared stmts in stored procs are only for testing but that plans ARE CACHED when prepared/called from external languages. Seems silly to me that PHP (from outside the MySQL engine) should have a performance advantage over stored procs but thats the way it is today........

The query I have is performing quite well and the RowNum value gives me what I need so long as it continues to behave as it currently does!!


Options: ReplyQuote

Written By
Re: circumventing limitations on the "Liimit" clause
January 23, 2007 12:49AM

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.