Open the recordset

[rezania]

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

[gwdash]

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