Hi,
Why SELECT * faster than COUNT(*) in network? I have a simple test as below:

FOR i =1 to 500
set rs = db.openrecordset('select * from mytabledbopensnapshot )
rs.close
NEXT i

it use 6 secs to finish.

However, if i use count(*)

FOR i =1 to 500
set rs = db.openrecordset('select count(*) from mytable',dbopensnapshot)
rs.close
NEXT i

it take 57 secs. why?

Thank you