Hi,
Thank you for infor.
I have tried the test for several times. However, it also return the same result
select * = 6 secs
select count(*) = 57 secs
I am using "\\myserver\c\mydata\data.mdb" to open database. Does it effect performance?
Again, I also tried to have test
select * .... where ... = 9 sec
select count(*) ... where ... = 8 secs
Any ideas?
Thank you
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...