Current time: 08-13-2020, 10:59 AM Hello There, Guest! (LoginRegister)

Post Reply 
 
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Database Query Search Time
08-23-2010, 03:05 PM
Post: #36
RE: Database Query Search Time
Hey Guys,

From what I have seen SOLR has float, double, integer, text, string, and other types. For product prices, I am now using custom3 to store price ranges and the title tag to store the actual prices. If I want to sort by price, I can just sort the title field.

It would be interesting to see if you can create your own fields in SOLR such as custom5, custom6, custom7, etc. However, if it is possible, CFINDEX only allows up to custom4. I suppose it would be possible to create a wrapper to do custom indexing.

I have written Adobe and said it would be nice if the CFCOLLECTION tag allowed more control over how the schema.xml file is setup. It would be nice if coldfusion could set field types, whether they are indexable, and create new fields if necessary. Instead of CFINDEX having a parameter for each field type, they could just have one parameter that accepts a CFQUERY that contains field name x value.

Product searches are usually pretty advanced. Coldfusion is only allowing enough fields to do searching on instead of fields that will be displayed in the search results. For example, I do not have enough variables to store a photo URL, the actual product description vs the summary, and the product name. When I am using coldfusion, I am focusing on returning only the KEY field which contain PRODUCT_ID numbers. From there, I can use CFQUERY to retrieve the product info I want displayed directly from the database. If coldfusion allowed more variables, that would reduce the number of round trips to the database.

On another note, it is probably a good idea to have two cfcollections of products. While one is getting updating using CFINDEX, the other one is searchable and will not get time out errors quite as easily.

I find that when using CFINDEX, it is best to have the indexing script called every 5 to 10 minutes. This supercedes what I said earlier in this thread. When I had times set less than 5 minutes, some problems occurred on the server. It is running more efficiently between 5 to 10 minutes. This would depend on your server setup.

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 - green-watch.org - 08-23-2010 03:05 PM
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)