Re: circumventing limitations on the "Liimit" clause

[Dewey Gaedcke]

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!!

Thanks
Dewey