Open the recordset

Hi
The OPEN statement on recordset for the larger tables is quite slow.
My application builds a tree (like the treeview example in VB6 samples),
and needs to open the recordset many times.(actually everytime any tree node is clicked).
Is there any way to improve the speed? sample codes are welcomed.
thanks
Rezania

Load the entire thing into several arrays or collections, then, load the treeview from the array. That might improve speed!