Has anyone else experienced this? I have a collection that is taking 90 seconds to do a CFSEARCH. It has probably about 10k-15k records in it. This is only ONE collection and it's doing a simple search. The collection has both files (word, pdf, excel) and data (from custom queries). 90 seconds is just unacceptable and I need to find out WHY it's taking so long and an alternative solution. Any thoughts or suggestions?
We are running CFMX 6.1 and cannot upgrade to CFMX 7 at this time. Thanks, Dave > I am having problems with CFsearch on a CFMX 6.1 install. I am > searching 50 collections that have a total of 23,491 records in them. > I have so many collections because when they are search just a few > areas it is much faster but when I need to do a search of everything > it takes for ever. Could I have a large PDF or badly formated PDF > that causes for the slow down? I am setting Maxrow return to 100. > This search worked with out much of any delays when the system was on > CF5. I just thought verity could perform quick search and I only have > 24,000 records. I would hate to see how slow it would be if I had the > full 750,000 records it says it can index. Any ideas on what I could > do different would be great. > Chris ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263687 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
