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

Post Reply 
 
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Database Query Search Time
08-25-2010, 03:25 AM (This post was last modified: 08-25-2010 04:19 AM by green-watch.org.)
Post: #44
RE: Database Query Search Time
Hey There,

Bulk inserts definitely makes CFINDEX work a bit better. I will tell you right now though it is not a solution to the maxWarmingSearchers problem. You will have to slow down the script as the collection grows larger. However, bulk inserts seem to allow more documents to be added in a given time frame that adding them individually. I just wish I had resources on my server to add a million at once instead of 10,000. Now it has me wondering how many documents I can really add at once. I plan on experimenting a bit before reindexing my entire product collection. Talk to you soon.

Update: I submitted another suggestion to the Adobe team. Bug / Enhancement Report 83931:

I think it would be nice if we could transfer information between a database and SOLR easier through CFINDEX. While we can do bulk inserts via CFQUERY, there are only so many rows we can transfer at once because of limited system resources. One parameter of CFINDEX could be "datasource" to establish a connection to the database. Another parameter could be FIELDLIST, which could be 2-dimensional array where one dimensional could be the database column name and second dimension could be the SOLR column name. From there, SOLR could insert the entire database via whatever means necessary through CFINDEX.

Update #2: I found some information regarding distributed SOLR searches:
http://www.ibm.com/developerworks/java/l...lr-update/

http://localhost:8983/solr/select?
shards=localhost:8983/solr,localhost:7574/solr&q=ipod+solr

More than likely, an application would set up the shards parameter values as part of the SolrRequestHandler's defaults configuration in the solrconfig.xml, such that the names of all the sharded servers do not need to be passed in with the query every time.


Update #3 - Submitted Enhancement 83933 to Adobe:

The SOLR documentation describes a way to give documents a boost in terms of their score value regardless of what the user is searching for.

<add>
<doc boost="2.5">
<field name="employeeId">05991</field>
<field name="office" boost="2.0">Bridgewater</field>
</doc>
</add>

Can we have a way to give documents a boost with CFINDEX?


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 - 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
RE: Database Query Search Time - green-watch.org - 08-25-2010 03:25 AM

Forum Jump:


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