Hi, Since these days, I am looking at optimization issues as you can tell from other posts, I have been thinking of pagination for quite sometime now. I have it working for a site and it works fine.
There are plenty of solutions out there and one provided by Ben Forta in his CF 7 book. I like these 2 impementations 1. http://www.johnwbartlett.com/CF_tipsNtricks/index.cfm?TopicID=72 2. http://paginationcfc.riaforge.org/ But if the query is run *every time* when you go to next page, inst it defeating the very purpose of pagination i.e. less load in performing query to get 1000's of records at once. Anyone knows how to tackle this problem, so that query is run once and then you can move around in the record set by next previous links. I am curious to know how other people are doing this. Thanks, <Ajas Mohammed /> http://ajashadi.blogspot.com We cannot become what we need to be, remaining what we are. No matter what, find a way. Because thats what winners do. You can't improve what you don't measure. Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives.
