I have a wizard that I'm adding 64 pages to in form load event. I'm also loading a treeview as an alternate nav method to pages in the wizard.



It is taking about 4-5 secs and I'd like to speed it up (or have the appearance of it speeding up...i.e. if it could be cached, that'd be fine). Any ideas? If pages could be inserted at a specific location, I'd have some of them set at design time, but 45 pages are data driven (45 with the current data), so that would only help some anyway.



Thanks!

Adding that many pages through code shouldn't slow down that much... 4-5 seconds is too long, I think.  I'm guessing most of your slow down is coming from the queries that you're running to populate the wizard with the pages.  If you run one query that returns "master" 45 records, one for each page, and then you run queries to gather the data for all of the controls on that page, you might be looking at around 100-200 queries to build the list.  What you could do is populate the collection on a thread behind the scenes... show something to let the end-user know that it's working while you're populating.

(as you know by now) I'm a noob at this stuff, so could you post a quick example of how to do this threading thing? I've done a bit of sewing, but that's about as much as I know about threading



Thanks!