| Author |
 Topic  |
|
|
MarkJH
Senior Member
United Kingdom
1722 Posts |
 Posted - 06 February 2006 : 18:53:30
|
What would be the side-effects of having thousands of forums (not listed on default.asp) in a Snitz forum? Would there be a dramatic slowdown, timeouts etc. or would it not make any difference to the overall speed of the forums?
Purely theoretical question...  |
Bandlink.net - http://www.bandlink.net/
Bandlink Music Forums - http://www.bandlink.net/forum/ |
|
|
-gary
Development Team Member
406 Posts |
Posted - 06 February 2006 : 23:06:36
|
| Thousands would be nothing. They only add rows to the _forums table. |
KawiForums.com
 |
 |
|
|
MarkJH
Senior Member
United Kingdom
1722 Posts |
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 07 February 2006 : 09:34:58
|
| Are you thinking of having a forum for each band ? |
|
|
|
MarkJH
Senior Member
United Kingdom
1722 Posts |
Posted - 07 February 2006 : 11:36:26
|
Yes, I was thinking about it.
I'm not sure how I could go about it yet but I was thinking something along the lines of having a unique number for each artist, then using some kind of SQL query to create all of those forums. They'd all link back to default.asp but only a select few would link down. I'd have a separate index for the forums, like I currently do for links, tabs and lyrics.
I think it would be a great service, particularly for new and unsigned artists and it should give my forums a huge boost in traffic.
I just haven't heard of Snitz being used this way before. So, it's all theory right now. Would make for a very exciting experiment, though. |
Bandlink.net - http://www.bandlink.net/
Bandlink Music Forums - http://www.bandlink.net/forum/ |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 07 February 2006 : 11:56:25
|
I need to talk with you about band-related sites now that I'm doing all the work with the Warsong Records crew....
As for the topic at hand, I'd be careful you don't make your default listing too big or you might discourage people from scrolling too far... not good for the people near the bottom of the list. |
|
|
|
MarkJH
Senior Member
United Kingdom
1722 Posts |
Posted - 07 February 2006 : 12:06:58
|
quote:
They'd all link back to default.asp but only a select few would link down.
 I don't think that many people would want to scroll through 8,500 bands and artists.  |
Bandlink.net - http://www.bandlink.net/
Bandlink Music Forums - http://www.bandlink.net/forum/ |
|
|
|
MarkJH
Senior Member
United Kingdom
1722 Posts |
Posted - 07 February 2006 : 16:38:11
|
| If the Auth Type of the thousands of newly created forums were set to 'Hidden Forum on Default', even though normal users wouldn't see those forums on default.asp, would it have a detrimental effect on the loading speed of default.asp? |
Bandlink.net - http://www.bandlink.net/
Bandlink Music Forums - http://www.bandlink.net/forum/ |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 07 February 2006 : 17:17:03
|
| Just a guess, but I think that the biggest bottleneck in that situation would be your DBMS... |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
MarkJH
Senior Member
United Kingdom
1722 Posts |
Posted - 07 February 2006 : 19:30:03
|
Couldn't I just set default.asp to only check forum_id's up to say 100 then start the other forums from a higher forum_id, and use static links to get to them, in a menu system such as this?
If there's a way around this without causing a bottleneck, I'd love to know. |
Bandlink.net - http://www.bandlink.net/
Bandlink Music Forums - http://www.bandlink.net/forum/ |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 07 February 2006 : 19:41:28
|
| Well you'd need to take a good look at the code. You could obviously make the forum behave differently for certain forum ID's, or better stillm for forum's with certain values (say a boolean variable that would distinguish between the normal forums and the other ones). Possible, it is, that's for sure. The exact code implications, I can't tell. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 07 February 2006 : 20:46:02
|
quote:
Originally posted by ruirib
default.asp would load verrrrrryyyyy sloowwwwllllyyyyy, specially for admins. Frankly speaking, I wouldn't consider such a situation.
Just for my own edification, why  |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 08 February 2006 : 06:46:14
|
| Ah. For some strange reason I was thinking about the forums being filtered in the initial SELECT statement..... |
|
|
| |
Topic |
|
Topic Locked
