[AccessD] Treeview Speed problems

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.
When a change occurs I add a new node at that level.

For example, if the structure is Parent, Child, Grandchild then I order
by Parent, Child, Grandchild. As you move through the recordset, if the
Parent is the same you just keep adding Child nodes and so forth. When
the next record has a different Parent you add a new node at that level.

You get to fully populate the tree from one sql string / connection. The
form may take a little longer to load, but once up its lightning fast.

I can post some code if you like... My brains been fried by Excel and a
couple of list boxes, so sorry if this isn't very clear :O)

Mark

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Sad Der
Sent: 16 July 2003 14:45
To: Acces User Group
Subject: [AccessD] Treeview Speed problems


Hi group,

i've got a problem with my treeview. The problem is
that it is too slow to work with. 
It's an A2K application with 2 databases (BE + FE).
I've looked at the code and it looks very good. For
instance:
- Only the 1st level of the tree is loaded at startup;
- when a node is clicked only it's childs are loaded;
- after a child is clicked the dataform is loaded
(dataform is on the same form as the treeview is);

I've installed the application locally and it's not
slow at all. So the problem is, i guess, that the 
BE is on a network drive and the FE is installed
localy. It's especially slow on the lowest level,
meaning that the tree is completely collapsed. 

The function used to fill that form is the same as
with the other child nodes...

I've read the article on databaseadvisor.com and the
tips and tricks mentioned there are 'all' used.
What else can I say?
The app is used rarely;
4 users = max;
2 users logged on at the same time is almost
impossible;
The server with the BE is in a building 'just around
the corner' (not in a diff country or so);

Is there something else that I can check?

Thnx

Sander

__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com