With this many records it may actually work out that a properly indexed DB with wel-written queries performs better than QoQ on a stored/cached query. Compare both and see what happens.
On 4/30/07, Mike Little wrote: > 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!) -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276535 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
