Database Query Search Time

[green-watch.org]

Hey Guys,

I want to thank you all for recommending SOLR to me. Most searches are returning results to me within a fraction of a second and that is with searching millions of records. It is so much more advanced than CFQUERY that really there is no comparison.

I have read about so many more features that SOLR supports that I have not talked about. For example, here are a few documents from the (http://lucene.apache.org/solr/tutorial.html) documentation:

http://wiki.apache.org/solr/DistributedSearch
http://wiki.apache.org/solr/FunctionQuery
http://wiki.apache.org/solr/StatsComponent
http://wiki.apache.org/solr/ClusteringComponent

I doubt that I will ever need to distribute my collections among different servers. It is nice knowing that SOLR has this functionality just in case. I have checked back on the Adobe recommendations I have submitted. Thanks in advance to all those who vote to expand Coldfusion SOLR capabilities. It is nice hearing about people coming from there to read this thread. I have submitted report 83909 to Adobe just now that is a suggestion for coldfusion to add distributed search support. There is a lot that coldfusion needs before this with their SOLR integration, but this support should be there as well.

Sincerely,
Travis Walters