if the data doesn't change frequently, you may be better off just caching the assembled page. hard to know without knowing more about the business problem at hand.
On 4/29/07, Mike Little <[EMAIL PROTECTED]> wrote: > hi neil, > > well potentially the client wants a large amount of property listings eg. > 1000+ ?? > > at the moment, running one SP for each type of listing eg. feature, then > doing a QofQ based on region seems to work ok - but i am dealing with very > small amounts for development. > > our model is a site here in nz http://www.trademe.co.nz (which obviously has > 10's of 1000's of records!) > > >A normal cache would be better I would say, probably less mem impact. How > >many rows are we talking about? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276524 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
