A problem difficulty for me but easy for you!

[jifenghu]

the problem is the fllowing:
1.Either a database or a table of it has so many records that it is wasting
time if we try to operate it in total any time .
2.I want to show some records page by page in the web page.At the same
time,maybe I have to sometimes list them order by some fields .
3.To do what 2 shows as quickly as possible,because users don't wait with
patience.how can I do?
thanks

 

[Steve Huff]

the problem is the fllowing:
1.Either a database or a table of it has so many records that it is
wasting
time if we try to operate it in total any time .
2.I want to show some records page by page in the web page.At the same
time,maybe I have to sometimes list them order by some fields .
3.To do what 2 shows as quickly as possible,because users don't wait with
patience.how can I do?
thanks

So which one is it the whole database or just one table? What do you mean
by "if we try to operate it in total any time."?? Your questions are very
poorly worded and it's difficult to figure out what you are asking.

I assume you have an Access database that you are using to drive a web page
and it's slow? First off -- Access databases are not the best choice for
web using especially with large amounts of data on heavily hit web pages.
You may consider moving to SQL Server if that is the case.

If it's not a heavily hit page you may just need to normalize you access
database which could trim it's size down and speed tremendously.

You can read more about normalizing data here:
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=88