Hello all,

I am currently querying my entire database and returning to the user about 1000 rows of data. Unfortunately, this can take a very long time. To solve this problem, I've decided to immitate the functionality at the bottom of Google search results pages, where it has "Next", "Prev" and then a count from 1 to some number.

I've look at Zend_Db_Select::limit so that I could provide a count, and an offset, but unfortunately the database I am querying can have inserts at the same time I am reading for the database, so it seems probable that if the user decides to visit the Next 10 entries, the data will be messed up because there were inserts into the database at the same time...

I hope this makes sense... any help would be great.

Hi,

Have you checked out the Zend Framework paginator component? This is likely the best way to go as it will eliminate the need for you to manually manage select limits.

See the Zend_Paginator section.

Hope this helps,
Jason