Page unavaliable

[jadec]

Hi Everyone,

I'm tring to display a large of data to webpage. I use loop statement: for i = 0 to rcdlength-1 ... next. If the data has more than 520 records, it display error page: page unavailiable. Someone told me to put response.flush inside the loop before every next statement. It works but takes a long time to display the page. Does anyone know this kind of problem? Do you have any solution?

Please help!

Thanks ahead!!

Jade C

 

[kaht]

520 records is not really very much data under most circumstances. More than likely you'll want to speed up your query. You might also want to look into using the ASP method GetRows to speed up the data transfer.

-kaht

Looking for a puppy?

[small]Silky Terriers are small, relatively odorless dogs that shed no fur and make great indoor pets.[/small]

 

[DotNetGnat]

paginate your recordset...

-DNG

 

[jadec]

I don't use ADO to retrieve data. I read data from a xml file. In my asp, I put all the data in an array first, then use

For i=0 to rcdlength -1 ... next

to display data. if i change for loop to

 for i=0 to 520 ... next

the data displyed ok.