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.