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-22-2010, 07:58 PM (This post was last modified: 08-22-2010 08:18 PM by green-watch.org.)
Post: #33
RE: Database Query Search Time
Hey Guys,

Be careful when sorting by a column when dealing with numbers. I tried to sort by custom3+desc and got these results:

10002,10004,10006,10008,10010,10016,10019,1002141,10022,10023

The incorrect sort in this sequence is obviously the 1002141. It appears to be reading left to right as if it were comparing strings. I believe adding "00" in front of all products except the 1002141 term and then sorting will yield correct results. I wonder if there is anyway to tell SOLR that a field is suppose to be numeric as opposed to text?

One thing I like most about SOLR is the timeAllowed parameter, which I started discussing a little in the last post.

To search for "gold" for no longer than 2 seconds, you can do this:
http://localhost:8983/solr/products_id2/select/?q=gold&version=2.2&start=0&rows=10&indent=on&timeAllowed=2000

With CFQUERY, you can specify a timeout. However, if the search time exceeds the timeout value, it throws an error instead of returning the results it found in the maximum time specified. CFQUERY is rather common with coldfusion. I really think they should add a TIMEALLOWED variable to CFQUERY. As soon as I can figure out where to make suggestions to the Adobe Coldfusion team, I have a few ideas I think they would like.

Update: I found that I can make suggestions to Adobe here:
http://cfbugs.adobe.com/cfbugreport/flex.../main.html

I opened reports 83899 and 83898.

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-22-2010 07:58 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)