long load time

[jaird]

i am loading an asp page with a table of information from an Access database. it worked fine, then i copied the code and added some modifications and it has stopped working.The query is the same but it suddenly takes a really long time to load the page and times out with only a few records added to the page. does anyone know why it takes forever for a query to execute?
thanks

 

[snowboardr]

Try adding this to the top of the page:

<% Response.Buffer=true %>

 

[GIGN]

I hope it's not a bad while loop - have you got your movenext in?
A bad while loop can crash a server quite nicely.

<bb/>

 

[Ovatvvon]

I think GIGN more than likely has hit it on the nose...make sure you added in your rs.movenext command to move to the next record in the database upon every loop.

If that isn't your problem...then you need to be more specific with what changes you made, and what your code says. If it was working before the modifications, and now it's not...then obviously that's your problem...so if anyone is going to be able to help you here...we'll need some sample code. -Ovatvvon :-Q