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...

We'll never know for sure unless you post the offending code, describe the table structure, and give us some information about what kind of indexes the table has.

In the meantime, make sure the table has a Primary Key (even if you just make an IDENTITY column for it) and the correct indexes to support your queries.

--Jeff Moden