Hi,

I have a database ,It has more data so when i run(execute)
a Select command, it took more time.

I need a very fast way to catch some data from database
and show the result of search to the user.

I'm vb programer and I use MS Access 97,2000 and MS SqlSqever 2000.

Tancks.

baloudeh

What is your SELECT statement? Can you post that here?

If using mssql server, index the table properly.

If search is involved check this out - SQL Server Full Text Search Optimization

Transact-SQL Optimization Tips

Full-Text Search Optimization Tips

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection