I'm having a serious problem. I open a recordset based on this: <b><i>"select a.city, a.st, a.zip, a.plus4, a.province, a.postal_code, a.fname, a.mi, a.lname, a.degree, a.affname from reg_resp b, registrant a where b.reg_id = a.reg_id and b.prog_id = " & Request("programid"
</i></b>. It's adOpenForewardOnly. The query runs in about 5 seconds. I start writing out an HTML table. All these statements take less than a second. <b>Then I get to my MoveNext and that statement takes 7 - 11 seconds</b> all by itself. I have other pages that do more complicated things and they load quicker (their MoveNext takes less than a second). Does anyone have a clue why this might take so long? Any help would be appreciated.<br><br><br>Thanks,<br>the rookie of the web
</i></b>. It's adOpenForewardOnly. The query runs in about 5 seconds. I start writing out an HTML table. All these statements take less than a second. <b>Then I get to my MoveNext and that statement takes 7 - 11 seconds</b> all by itself. I have other pages that do more complicated things and they load quicker (their MoveNext takes less than a second). Does anyone have a clue why this might take so long? Any help would be appreciated.<br><br><br>Thanks,<br>the rookie of the web 