Current time: 01-22-2021, 11:23 PM Hello There, Guest! (LoginRegister)

Post Reply 
 
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Database Query Search Time
08-18-2010, 11:20 PM (This post was last modified: 08-18-2010 11:49 PM by green-watch.org.)
Post: #30
RE: Database Query Search Time
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
Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
RE: Database Query Search Time - pmeenan - 07-04-2010, 12:03 PM
RE: Database Query Search Time - pmeenan - 07-05-2010, 04:35 AM
RE: Database Query Search Time - sajal - 07-05-2010, 05:03 AM
RE: Database Query Search Time - pmeenan - 07-08-2010, 08:47 PM
RE: Database Query Search Time - sajal - 08-13-2010, 10:06 PM
RE: Database Query Search Time - sajal - 08-14-2010, 03:38 AM
RE: Database Query Search Time - sajal - 08-14-2010, 06:50 AM
RE: Database Query Search Time - pmeenan - 08-16-2010, 02:55 AM
RE: Database Query Search Time - sajal - 08-17-2010, 01:14 AM
RE: Database Query Search Time - green-watch.org - 08-18-2010 11:20 PM
RE: Database Query Search Time - pmeenan - 08-23-2010, 01:22 AM
RE: Database Query Search Time - pmeenan - 08-23-2010, 08:45 PM
RE: Database Query Search Time - ringman57 - 08-24-2010, 11:52 PM
RE: Database Query Search Time - ringman57 - 08-25-2010, 02:54 AM

Forum Jump:


User(s) browsing this thread: 2 Guest(s)