HI FRNDS,

          I have one database with 10 lacs records. But the problem is that when I am searching one particular data, it is taking few seconds to search. Is there any way to reduce this time???

Thanks in advance...

Hi ,
1) Have u used Index. U can index the colum which u use in ur where condition.
2) are u using Stored Procedure . Do it if not.

If still it runs slow. We must look at other options