[AccessD] Treeview Speed problems

Hi Sander

I had a brief look at the 'Access VB SQL Advisor' demo and it is no
wonder why the slow version of the treeview form is that slow; she
loads the full tree by creating and running a subquery for each and
every node.
The fast version loads levels/nodes as needed which increases speed
for the initial load by a factor five. If you have one fast query
retrieving all nodes in one go I'm not sure the speed increase will
be that large.

/gustav


> That's something I had in mind also. I'll give it a
> shot. It should make the treeview fast but I think I
> would still have the problem to display the form data
> for the item clicked....hmmm I'll have to think that
> one through!

> Thnx for the replies.

> Sander


> --- Mark H <Lists at theopg.com> wrote:
>> Can you populate it in one pass by joining the
>> necessary tables together
>> in your SQL. I have done this before and used the
>> order by to get the
>> data sorted in a way which allows me to scan for
>> changes in key values.