> 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.
Are you sure this is a Verity problem, or when you pull back database results are you doing anything else along the way? > 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. Your database may provide full-text indexing functionality, which may well work better than Verity - SQL Server's full-text indexing works very nicely. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:259650 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
