Database Query Search Time

[green-watch.org]

Hello Again,

To improve performance with SOLR, there is a small tweak that can be made that is described here:
http://help.adobe.com/en_US/ColdFusion/9...-8000.html

This increases the amount of memory that SOLR can use, which leads to better performance if you have a system with a bit of available memory.

One of my next goals is as follows: My custom3 field contains a "PRODUCT_PRIORITY_ID", which indicates how well the product ranks in terms of "greenness". If I can use SOLR to order by the custom3 field, then results should be sorted by greenness.

Edit: It would also be nice if there were a way to specify which columns should be returned in the query when using cfsearch. I find the summary field useless and would rather display my own description. Having it return this column wastes memory that I could be using to retrieve even more results.

Sincerely,
Travis Walters