my query is slowing down!

[wengang]

Hi all.
I guess the first thing I need to know is:
if I set the pagesize of my recordset for an Access database, connected by ADO, does the size of the datatable still affect the speed of the query?

My datatable has about 30,000 records and growing. The query retrieves all records, but the pagesize is 100 records. So, I am thinking that, regardless how many records there are, only 100 records are being dealt with whenever the page loads (ASP), and therefore the speed should remain constant. is that wrong?
This page has started taking forever to load. The amount of data in each record is pretty small. Only a few fields and mostly numbers

Okay, besides that, a couple of basic questions. Am I doing this in an inefficient manner? Is pagesize not the way that sites display X records per page?
This is my current system. Please advise if you'd do it differently:

SET rs6=CreateObject("ADODB.Recordset")
sql6 = "select * from tblPageLog"
rs6.Open sql6,conn,1,3
rs6.pagesize=100
rs6.absolutepage=request("page")
for t = 1 to rs6.pagesize
if not rs6.eof then
'display the data in a table......
rs6.movenext
end if
next

And, I also have a SqlServer database on this site. Can anybody tell me definitively if SQLServer is faster in any sense than Access? I've been thinking of moving the whole site to SQLServer.