Urgent-ado sql speed

[Gurbuly]

and if you don't need to edit the data in the recordset avoid opening it dynamically..adOpenDynamic, if you can get away with it use adOpenForwardOnly,adLockReadOnly