Is dll faster to retrieve data from a database?

[BravoTwoZero]

Hi,

I am conducting a test by creating a dll to retrieve 3880 records of business details in one page! unfortunatly thats what my client wants! I have tried to test on an adsl line and gave me error: 'Page cannot be displayed' or 'server times out'.

With your professional views, can you suggest any faster methods to retrieve 3880 records in one page? I am using SQL2000 and com object in an asp page in order to display. My client requested no page numbers in the asp page. A one big list of records.

I am most grateful

Bravo

[Zaphod Beeblebrox]

A timeout when retrieving 3880 records isn't good, that shouldn't be able to happen.

So, either the tables aren't indexed properly, or the timeout value is set too low.

I'd check the indexes first...

[BravoTwoZero]

Thank you for your answer.

Have you ever used microsoft transaction server? any benifits to use it? my worry is by next year the record will increase to 5000. What is the benifit of using MTS?