[AccessD] Treeview Speed problems

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.
> 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
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com


__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com