Stephen Bond
stephen at bondsoftware.co.nz
Wed Jul 16 17:34:50 CDT 2003
Sad, I tend to populate TreeView controls by populating each level of the tree in its entirety before proceeding to the next lower level. I can't remember where I got the idea from, it's been a while ... but there is an article in the June 2003 edition of 'Access VB SQL Advisor' page 18ff, where the author has done some comparison tests on loading a tv control in various ways. Her results put meat on the bones of my suspicion. The speed increase using the above method was quite dramatic. Stephen Bond -----Original Message----- From: Sad Der [mailto:accessd666 at yahoo.com] Sent: Thursday, 17 July 2003 1:45 a.m. 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