Hi, everyone. A friend of mine has a bunch of data currently stored in InMagic's DBTextWorks. This data is a series of document records. Each record has several fields with general information (author(s), publication date, etc.) and a field with the body of the document. This last field, of course, is rather enormous compared to the other fields. His current tool works very well for this particular application. Looking into the future, though, he is starting to think that it might be wise for him to consider moving it all into ColdFusion with an Oracle back end. He came to me to ask whether I had any ideas.
Unfortunately, I know very little about search features in ColdFusion. The best advice (not so good) that I could give him was to have a nightly batch job that would concatenate all fields from a single record and enter it into a single field of a new table. Then it could do a Verity index of this single column, allowing advanced searching across the record. He wondered whether there was a better way, and specifically whether there was a better way to do live queries without this sort of nightly batch job. His initial stab, an extremely complicated SQL statement, was prohibitively slow. So I'm writing to you all to find out if there is a better way. I don't want anyone to solve the problem; that's too much to ask. But if anyone can suggest some places where my friend might look, some ideas that he might search on for reading, he and I would be very grateful. To better define the issue, here are some pretend, but more or less accurate, details: approx. 120,000 records single table: GeneralInformationColumn1 50 characters GeneralInformationColumn1 50 characters GeneralInformationColumn1 50 characters GeneralInformationColumn1 50 characters GeneralInformationColumn1 50 characters GeneralInformationColumn1 50 characters GeneralInformationColumn1 50 characters GeneralInformationColumn1 50 characters ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
