>MSSEARCH isn't crap Stephen, it's actually quite good. In my tests it is operating faster than verity.
really?? Are you sure its not because you're using CONTAINS instead of STEM searches and other text indexing/retrieval type stuff etc? (he says struggling for a suitable Information Library Management type term)
CONTAINS will be a damn site quicker than a full stem search, as it will look for exactly what you enter in the query. eg. searching for "appearing" with CONTAINS will get you just that. A STEM search will look for all versions and tenses of "appear".
I suspect that you aren't going to be able to get past that.I have indexed over 20million records with the FULL-TEXT Search and am getitng results back in seconds. The only problem is the time to create the flippin catalog.
Is there a reason for full replacements of the database, rather than only those records that have changed? Can you get the client to update the database, rather than the originating flat files?
Stephen
-- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
