>I tried setting the datetime variables and looking at them. It takes about 5 minutes for the code to execute. The only thing I found that speeds the code up is to use a second table with a memo field. I create a row for each row of my html table. Then I do a second scan through that table storing everything in the memo field to a variable this cuts the time to about 1 minute. I can't understand why that would be faster. The machine I am running on is Pentium 200 with 96 meg of ram.

Along with what Eric states I would run a test limiting the number of records you are returning in the table. Say 100 for the first try and see what the speed is, then up it to 500, etc.. I use FoxWeb and tables to display data all the time, but using the web I am careful not to return too much to the user. I limit the queries to only certain amount of rows at a time. I have also hit I.E.'s limit on how much can be sent back without the users computer running out of resources (I had a table with several drop downs and input fields).