Consequences of having thousands of forums

[JonnyQuest]

I am interested in offering a "guestbook" to every registered user by giving them a small, customized forum, with it's Display Order = 0.
What sort of performance issues will I see if I have >5000 forums? Currently, I find that the main forum page can be very slow, will this slow this down to a crawl?

Also, I can easily see how to call the script which adds the forum with any particular settings I would like, however, I would like to also automatically make each user the moderator of their forum. Any thoughts on this script?

Finally, the concept of having over 5000 forums when I'm in the admin tool frankly scares me. The pull-downs in setting permissions...the modify forum area...all these will become huge pages and extremely cumbersome. Is there any (easy) way to have these guestbooks created in a seperate table in the db or in an entirely new db, yet still use the main db for user info?

[JonnyQuest]

bump. Any thoughts on this John?

[John]

Sorry about the delay in replying...

Unfortunately, the home page does seem to be some sort of bottle neck at the moment, and I am trying to find out why. I have been investigating the indexes used in the database, and I will make sure that these get added in the next version. They will increase the performance.

I think that your other questions are probably best address to the code hacking forum for now.

It would not be easy to go having them in a separate table. You could hack the admin code to only display certain forums though, or omit those with displayorder = 0.

John