Skip navigation
Srinivas Krishna
Srinivas Krishna Calculating status...
Currently Being Moderated

Best way to build search functionality

Aug 14, 2012 2:55 AM

we have a search functionality for the searching the order details. we have around 5 lacs+ orders and its taking so much time to get the details. we have indexed the DB fields but still too slow.

 

Now i am looking to buikd the search functionality with the verity, so i am checking how much helpful is this as everyday we get new orders and rerunning the query will take so much time.

 

when building the indexes for the first do i need to get all the records from the DB, if that is the case it will take so much time in the production and may impact to the production DB server.

 

can any one suggest best solution.

368 Views   2 Replies   Latest reply: Little_Mike, Aug 20, 2012 8:02 PM
 
Replies
  • Dan Bracuk
    Currently Being Moderated
    1. Dan Bracuk,
    Aug 14, 2012 5:43 AM   in reply to Srinivas Krishna
    Report

    Consider moving old data to another table.

     
    |
    Mark as:
  • Little_Mike
    Currently Being Moderated
    2. Little_Mike,
    Aug 20, 2012 8:02 PM   in reply to Dan Bracuk
    Report

    We use very large collections with SOLR, and the intiial index should not be too bad.  We have collections with 500k records, and it takes ~5-10 minutes to index (CF runs this in the background and it does not use JRUN.exe to perform this task)

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points