I have a treeview control which gets populated by data from an SQL database but it takes about 7 - 10 seconds to populate the view. The table that I'm populating it with has about 246 entries which shouldn't be a bit issue for sql. Why is this happening?

Drawing 246 items on your treeview will take a little bit of time. It likely isn't the database that is causing this, but the drawing of the nodes.

You can increase the speed somewhat by using the BeginUpdate method of the treeview prior to inserting the nodes, then using the EndUpdate method after all the nodes have been added. This will prevent re-drawing the treeview until all of the nodes have been added, which is really what is the likely culprit for the slow response time.

A better way of doing this is to add the parent nodes only when the form is loaded, then make a call to the database to populate that particular node with its children when it is clicked.

J