The search queries can be a little long because you end up with several joins, but they are fairly efficient in the database. Spectra uses these tables:
types objects propertydefinitions properties You can use CFINDEX against the documents by type, for instance, and that gives you an easy search interface for general searches. Still, I don't think Verity gives you an advantage searching on the metdata for structured information like keywords, unless the metdata contains longchar/text fields (which Spectra allows in the properties table). Verity might give you an advantage with large sets of documents, I guess it depends on your database server. The XML route is attractive and makes it easier to share data in a world where everything is done via Web services. But how would you index and search all those documents? It would be great if Verity supported structured indexing of XML files. Verity in CFMX 7 does support categories and category trees, which you might be able to use to get the data you want in the right structure. Prior versions of CF do not appear to support category or categorytree. >I've thought about that strategy, but I'm wondering how hard search >queries would be to write against that type of structure. Another >thing I forgot to mention is that I have an XML file with all the >keywords and the pdf file name in it. I'm wondering about keeping >appending these individual XML files into a larger "document type" >specific XML file..... > > >On Tue, 22 Feb 2005 18:18:43 -0400, Robert Munn <[EMAIL PROTECTED]> wrote: >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196029 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54