sir,
I have created functions that search new record into existing millions of records.but it takes more time in searhcing and displaying the result. i have created indexes.
we also apply concept of jobs but jobs works sequentially on a single server and searching time is almost same.
For improve performance.
What should I do?