Hi all, One of the sites that I manage is very DB intensive with very little static pages. I've been using the built-in Verity search engine to index a query of products and build a collection accordingly. But when searching for a product, its just way too slow for the amount of results that it pulls back. The same engine, when pulling back a collection of static page info on another site, is substantially quicker.
So, I'm wondering if there's a way to speed up the collection results or if there's a better alternative for DB-intensive search capabilities. Any advice would be appreciated. Rey... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259640 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
