The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
I've seen some sites with only just a few forums and a lot of posts. And, then I've seen sites with several forums and a lot of posts. I mean that I have seen a lot of posts either way, but the amount of forums were usually either few or many.
If there are a lot of members on at the same time and often, which is a better set-up for a Snitz site? Does it the database, server, etc. perform any differently between the two set-ups?<
If there are a lot of members on at the same time and often, which is a better set-up for a Snitz site? Does it the database, server, etc. perform any differently between the two set-ups?<
آخرین ویرایش توسط
نوشته شده در
it entirely depends on what your members do.
if lots of them visit default.asp then it is best to keep the number of forums low, if they rarely visit default.asp then the number of forums is pretty irrelevant. It is always best to keep the number of unarchived posts lowish as it helps with performance especially searching<
if lots of them visit default.asp then it is best to keep the number of forums low, if they rarely visit default.asp then the number of forums is pretty irrelevant. It is always best to keep the number of unarchived posts lowish as it helps with performance especially searching<
نوشته شده در
Thanks Huw. Personally, I like the fewer forums because of less remembering what forums do what, but I have seen the several forums approach that was done nicely and in good taste too.
I forgot to ask. Is your answer the same about searches ... regarding the amount of forums as in it is irrelevant?
Thanks again! <
I forgot to ask. Is your answer the same about searches ... regarding the amount of forums as in it is irrelevant?
Thanks again! <
نوشته شده در
the only relevance with forums on the search is to the load time of the search form, it should not have much effect on the actual searching.<
نوشته شده در
I have plenty of forums on GAPE as you can see, and I'm still using Access DB (60Mb now) and I'm starting to have problems in some posts when the user gets the error script timeout when showing the pages of a post.
I know that SQL will be much better, but I still hadn't the courage to pass all to SQL
FORUM_REPLY has 32900 rows
FORUM_TOPICS has 2700 rows<
I know that SQL will be much better, but I still hadn't the courage to pass all to SQL
FORUM_REPLY has 32900 rows
FORUM_TOPICS has 2700 rows<
Bruno Alexandre
(Strøby, DANMARK)
"a Portuguese in Danmark"
MOD's contribution to Snitz community * Facebook Module *
RSS Snitz Multiple Feed *
Online videos (Youtube, Google video, Flash, Quicktime, etc) *
Add avatar with image crop (on the fly) *
Show last messages in the forum *
Show how many messages since yours IN PAGE TITLE *
Updated version of Gender MOD *
Fly to the top instead of jumping *
an idea: iPhone version of Snitz
<mySnitzForum>GAPE</mySnitzForum>
(Strøby, DANMARK)
"a Portuguese in Danmark"
MOD's contribution to Snitz community * Facebook Module *
RSS Snitz Multiple Feed *
Online videos (Youtube, Google video, Flash, Quicktime, etc) *
Add avatar with image crop (on the fly) *
Show last messages in the forum *
Show how many messages since yours IN PAGE TITLE *
Updated version of Gender MOD *
Fly to the top instead of jumping *
an idea: iPhone version of Snitz
<mySnitzForum>GAPE</mySnitzForum>
آخرین ویرایش توسط
نوشته شده در
Thanks guys!
I just didn't want to stack the deck up on a couple of forums only to have performance degrade in the long-run. I suppose I am simple, but I really do like the few approach most of the time.
Hey, Bruno at 60 MB does that mean that your archives are many? It looks like you have about 35,496 non-archived posts.
<
I just didn't want to stack the deck up on a couple of forums only to have performance degrade in the long-run. I suppose I am simple, but I really do like the few approach most of the time.
Hey, Bruno at 60 MB does that mean that your archives are many? It looks like you have about 35,496 non-archived posts.
<
نوشته شده در
I have nothing archived
I read so many posts regarding problems retrieving and searching archived posts, that I do prefer to have all open and searchable.
...or I did misunderstood the Archive function?<
I read so many posts regarding problems retrieving and searching archived posts, that I do prefer to have all open and searchable.
...or I did misunderstood the Archive function?<
Bruno Alexandre
(Strøby, DANMARK)
"a Portuguese in Danmark"
MOD's contribution to Snitz community * Facebook Module *
RSS Snitz Multiple Feed *
Online videos (Youtube, Google video, Flash, Quicktime, etc) *
Add avatar with image crop (on the fly) *
Show last messages in the forum *
Show how many messages since yours IN PAGE TITLE *
Updated version of Gender MOD *
Fly to the top instead of jumping *
an idea: iPhone version of Snitz
<mySnitzForum>GAPE</mySnitzForum>
(Strøby, DANMARK)
"a Portuguese in Danmark"
MOD's contribution to Snitz community * Facebook Module *
RSS Snitz Multiple Feed *
Online videos (Youtube, Google video, Flash, Quicktime, etc) *
Add avatar with image crop (on the fly) *
Show last messages in the forum *
Show how many messages since yours IN PAGE TITLE *
Updated version of Gender MOD *
Fly to the top instead of jumping *
an idea: iPhone version of Snitz
<mySnitzForum>GAPE</mySnitzForum>
آخرین ویرایش توسط
نوشته شده در
From my experience when the archives become very large, it is often difficult for the standard Snitz search to finish without timing out. This isn't a snitz flaw. I don't think.
This problem is a bit the result of when archiving is not performed regularly. So, when the archiving times out and then the same forum is archived again, the replies get duplicated in the archives because the originating topic does not get the point where it can be successfully deleted (again, this is because the replies did not finish archiving).
If it will help you, I wrote a little mod that helps with archiving in more segments than the standard Snitz allots for: http://forum.snitz.com/forum/topic.asp?whichpage=2&TOPIC_ID=67666#384563
You may want to contact your host to find out the longest time that they allow a script to run on your account. That may help you gauge what is going on.
I need to do something more to my little mod like check to see if the reply_id being archived is already an existing REPLY_ID in the FORUM_A_REPLY table. If it is, then skip it, and move on to the next reply_id and verify it until the process can start fresh with the correct reply_id in order to start the archiving process again. Also, for existing reply_ids that are duplicated, do a count of the archived reply_id, and if the count is more than 1, then delete the duplicates else skip it. That would actually be the first process I would run, and make the other a separate process. I am thinking that these things might help with cleaning up duplicates and not duplicating reply_ids in that table. Maybe it might take some of the fear factor out of archiving.
Honestly, I think duplicates happen more often than not because folks don't realize about the archive process timing out due to server limitations. Then the duplicates occur, and folks get frustrated and move on and away from it. In a perfect situation though, I assume that the standard Snitz archive process would work flawlessly.
<
This problem is a bit the result of when archiving is not performed regularly. So, when the archiving times out and then the same forum is archived again, the replies get duplicated in the archives because the originating topic does not get the point where it can be successfully deleted (again, this is because the replies did not finish archiving).
If it will help you, I wrote a little mod that helps with archiving in more segments than the standard Snitz allots for: http://forum.snitz.com/forum/topic.asp?whichpage=2&TOPIC_ID=67666#384563
You may want to contact your host to find out the longest time that they allow a script to run on your account. That may help you gauge what is going on.
I need to do something more to my little mod like check to see if the reply_id being archived is already an existing REPLY_ID in the FORUM_A_REPLY table. If it is, then skip it, and move on to the next reply_id and verify it until the process can start fresh with the correct reply_id in order to start the archiving process again. Also, for existing reply_ids that are duplicated, do a count of the archived reply_id, and if the count is more than 1, then delete the duplicates else skip it. That would actually be the first process I would run, and make the other a separate process. I am thinking that these things might help with cleaning up duplicates and not duplicating reply_ids in that table. Maybe it might take some of the fear factor out of archiving.
Honestly, I think duplicates happen more often than not because folks don't realize about the archive process timing out due to server limitations. Then the duplicates occur, and folks get frustrated and move on and away from it. In a perfect situation though, I assume that the standard Snitz archive process would work flawlessly.
<
آخرین ویرایش توسط
نوشته شده در
if it is true what you are saying... why not perform a TOP 100 or even 200 and archive that... for example, archive the first 100 topics that were not archived.
this will never take that much time and it is possible to give a nice progress bar to the user.
What do you thing? wanna try do this (MOD) with me?<
this will never take that much time and it is possible to give a nice progress bar to the user.
What do you thing? wanna try do this (MOD) with me?<
Bruno Alexandre
(Strøby, DANMARK)
"a Portuguese in Danmark"
MOD's contribution to Snitz community * Facebook Module *
RSS Snitz Multiple Feed *
Online videos (Youtube, Google video, Flash, Quicktime, etc) *
Add avatar with image crop (on the fly) *
Show last messages in the forum *
Show how many messages since yours IN PAGE TITLE *
Updated version of Gender MOD *
Fly to the top instead of jumping *
an idea: iPhone version of Snitz
<mySnitzForum>GAPE</mySnitzForum>
(Strøby, DANMARK)
"a Portuguese in Danmark"
MOD's contribution to Snitz community * Facebook Module *
RSS Snitz Multiple Feed *
Online videos (Youtube, Google video, Flash, Quicktime, etc) *
Add avatar with image crop (on the fly) *
Show last messages in the forum *
Show how many messages since yours IN PAGE TITLE *
Updated version of Gender MOD *
Fly to the top instead of jumping *
an idea: iPhone version of Snitz
<mySnitzForum>GAPE</mySnitzForum>
نوشته شده در
Sure, I don't mind helping.
<
<
نوشته شده در
I'm still having problems this morning with my outgoing mail server, so I may not be able to respond via e-mail anytime soon that I know of at the moment.<
Email Member
Message Member
Post Moderation
بارگزاری فایل
If you're having problems uploading, try choosing a smaller image.
پیشنمایش مطلب
Send Topic
Loading...