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 GeneralInformationColumn2 50 characters GeneralInformationColumn3 50 characters GeneralInformationColumn4 50 characters GeneralInformationColumn5 20 characters GeneralInformationColumn6 20 characters GeneralInformationColumn7 20 characters GeneralInformationColumn8 20 characters .. GeneralInformationColumn20 20 characters BigText1 100000 characters Needs ability to do boolean searches that span columns. In other words, a search for A AND (B or C) would get a hit if a single column contained A and B, or if one column contained A and another contained C. Thanks in advance for any help you can send. Matthieu ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
