i've got a search tool on my site currently using the Verity search tool that comes with coldfusion.. i keep getting problems with the Verity which in turn makes myself or someone else waste hours reindexing the verity.. what i want to know is whether or not i should just get rid of the verity search and replace it with an sql search that i've created.. any information on verity would be appreciated.. like how it works etc. whether or not it's increase in performance is worth the time to reindex.. it also seems that whenever a record is added, removed or modified in verity it takes far too long... as far as i can see verity works simply be creating an additional unseen table to store a row for each item to be indexed.. so it speeds up the searching process by not having to join multiple tables with additional columns??? also, from what i've read the verity server that comes with coldfusion has a maximum of 250 000 documents.. and i'm somewhere around 400 000.. is this a major issue?