Nick G wrote: > Select * From > ( > Select rownum rnum, p.* From > ( > SELECT count(1) Over() totalCount, a.columns, b.columns FROM > table a, table b WHERE a.id = b.id ORDER BY a.name > ) p > Where rownum <= #Abs((start + Limit) - 1)# > ) > Where rnum >= #start# >
Yeah, that's kinda similar to what I did using the MySQL-specific LIMIT statement. It seems to work well - I just didn't know if using caching would or wouldn't be the right thing to do, especially when I have 60k records. Obviously there are many ways to skin the cat, just trying to find the best way. Now, when people are dealing with query caching, how many records do you pull out, generally speaking? What if you get to the end of the cached recordset, is it normal practice to have to put logic to run another query and cache those results? > The paging is simple enough to implement and even easier using EXT. > Obviously if you're not using Oracle this won't work but I'm sure the other > db's have a similar way to accomplish this. I'm assuming EXT is Oracle-specific? I'm using MySQL. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319571 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
