We have a Physical file which has more than 60 million records in it. In our application we search for the particular records based on 6 fields as a search criteria (web based) , search process are done in SQL Procedures. Even when i creatd a LF based on the mandatory search fields , we get a timeout exception error.How can that be rectified.
!.Tried with Lf , not much difference.
2.Tried using fetching first 300 records also takes more time.
Can anyone help me out on how the search results can be made faster.
Thanks in advance
December 15, 2009 11:08 AM
December 17, 2009 7:08 PM