<div>
Change to SQL Server Express :)<br />
<br />
How long is it taking and what are you doing with the records? If you are trying to display that much data it will take a little while...
</div>


<div>
you can opt to use temp tables to view the data through a stored proc, check out the site below...<br />
<br />
<a href="http://www.sqloptimizationsschool.com/Pages/Basic%20Concepts/Temp%20Tables.aspx" rel="ugc">http://www.sqloptimizationsschool.com/Pages/Basic%20Concepts/Temp%20Tables.aspx</a>
</div>


<div>
Have you tried compacting the file lately? Sometimes running an Access DB for a length of time can bloat the file and cause queries to slow.
</div>


<div>
<div class="content wysiwyg-content">
Hello experts,<br />
<br />
I am using the access database. I have one table with 20,000 records and when i am using the query select * from tablename from .aspx page with C# then system is taking too long to execute the query.<br />
<br />
What is the best possible way to fetch the records.<br />
<br />
Any helping hands will be greatly appreciated.<br />
<br />
Many thanks
</div>
</div>


Hello experts,

I am using the access database. I have one table with 20,000 records and when i am using the query select * from tablename from .aspx page with C# then system is taking too long to execute the query.

What is the best possible way to fetch the records.

Any helping hands will be greatly appreciated.

Many thanks

query optimization

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).