Current time: 01-28-2021, 07:52 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, 07:20 PM
Post: #29
RE: Database Query Search Time
Hey Guys,

I think it is an important note for SOLR users to understand when they add, edit, or delete products in their database, they should also update the collection.

To delete a product from the collection, you can do something similar to this:

Code:
<cfindex collection="#collectionName#" action="delete" key="#URL.productID#" type="custom">

To add or edit products in the collection, the script I posted in this thread will do that. However, when you edit a product in the source database, you should set the PRODUCT_INDEXED value to 0. When you add a product, the PRODUCT_INDEXED should also be set to 0.

The "maxWarmingSearchers" error is no longer appearing now that I am repopulating the cfcollection.

After the mass product add takes place, it may take several minutes for the cfcollection doccount to update. I set the time interval between massive adds to 4 minutes. This is a bit slower but the script is executing better. I have about 2 million products in the collection right now and 3.6 million to go.

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 07: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: 1 Guest(s)