>We don't have a SQL server yet. The speed of the archives comes from (or >will) a really funky caching system where each thread (with all messages) >will be cached until a new message is added to the thread. The indexing >will be done on a message basis rather than a thread one. This will allow >the incremental additions. Once we get a SQL box, I'll look into what you >suggested. As a side note, we have over 12,000 threads and 66,000 messages >in the CF-Talk archive alone. My concern with the indexing was if a verity >collection can handle 100,000 or more items in an index. >The current archives are from jan 2001. I'm getting access2000 to convert >the older posts into archivable threads as well so we can have back to the >start. This will at least double the current message count.
Michael, Out of curiosity, why port the threads that are older than Jan 2001? I doubt that much of that information will be overly useful, considering that CF has gone through 2 more releases. Also, I would bet that a lot of the "nuggets of knowledge" from back then have probably been discussed over and over again after Jan 2001. Personally, I would be happier with speedier searches (due to less records being searched) with more relevant search results. I don't really need CF 3.1-related threads! I believe you said you were putting filters into the search interface. But pre-Jan 2001 seems to be a little too old. That's just my two cents that I'd be curious to hear your feedback on. Thoughts? Thanks again for all your work with cf-talk. It's easily the most valuable CF resource available. Regards, Dave. ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
