News Feed
Jobs Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Daniel Cousineau's Blog:
Doctrine 1.2 MSSQL Alternative LIMIT/Paging
September 17, 2010 @ 11:34:03

Daniel Cousineau has a new post to his blog today looking at an alternative that can be used for pagination in your MSSQL queries than the trick with TOP and reversing the ORDER BY in Doctrine.

As ugly as this technique is, it works. The problem is it requires an extreme amount of intelligence or an extreme amount of simplicity in the query in order for an automated system like Doctrine to be usable. The biggest caveat with this technique is good goddamned luck paging your query if it doesn't have an ORDER BY. And sometimes queries that are complex enough break the modified Zend_Db code. There exists an easier MSSQL paging technique. Using features first available in SQL Server 2005, with only 1 subquery you can mimic MySQL's LIMIT clause with ease.

He includes the query that will make it happen (the SQL for it) and then the implementation as an adapter you can use to get it to cooperate in your Doctrine queries.

0 comments voice your opinion now!
mssql doctrine limit paging adapter


blog comments powered by Disqus

Similar Posts

GotoTech.com: Developer Diary: Taming Doctrine’s 2000 Flushes

Juozas Kaziukenas' Blog: Zend Framework and Doctrine. Part 1

ZendCasts.com: Doctrine Relations and Zend MVC

Lukas Smith's Blog: Chatting with Rasmus (part one)

Ade Slade's Blog: Integrating Zend Framework 1 and Pimple


Community Events











Don't see your event here?
Let us know!


install hhvm unittest code podcast framework component symfony2 introduction composer package language dependency facebook application security series hack release opinion

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework