InstantASP Community Forums / Old Forums / InstantForum.NET 4.x / Suggestions & Requests / Discussion: Forum Archiving / Latest Posts

RE: Discussion: Forum Archiving

dotnetwebs — Fri, 17 Nov 2006 14:02:15 GMT

Ryan your best customers are raising serious issues here. You asked me why I think this product is under-supported.

NEED I SPELL IT OUT TO YOU!!!!!!!!!!!!!!!!!1

RE: Discussion: Forum Archiving

Mark Christianson — Fri, 17 Nov 2006 06:21:16 GMT

Mines up over 600... Ive brought this up a multitude of times even offline. believe me when I say that its one of the key things that WILL happen in the upcoming release because I think Ryan is sick of my badgering him.

RE: Discussion: Forum Archiving

Bare — Tue, 14 Nov 2006 11:10:20 GMT

Agreed on all things stated above :D

SQL Disk space is expensive...

One option in regard to memory... is to setup SQL server to use a fixed amount of memory... thus leaving enough memory for IIS (or any other apps).

If you have enough ram & Windows 2000 or 2003 Advanced Server... You can enable the /3GB & /PAE switches on the Windows level. The /3GB switch will clear up 1GB of ram for applications (as Windows reduces its base memory usage). Together with the /PAE switch... you can then use the AWE option within SQL Server 2000 and above... which allows the SQL Server process to use a significant amount of memory (if it is available on the server)(fixed amount is preferred). The larger the SQL data cache.. the fewer I/O requests... thus greater performance.

I work with some really big SQL DB's... and it has come a long way since 6.5... LOL (and 64bit SQL Server 2005 is light years ahead of any previous version).

Wow... I started babbling... and you probably know all this already.. I'll shut up now... Sorry :w00t:

RE: Discussion: Forum Archiving

ssinchak — Sun, 12 Nov 2006 22:00:46 GMT

My database is well over 900MB! Anyone that uses SQL Server knows that MSSQL likes to put that whole DB into ram and it is starting to affect the amount of RAM available to IIS. This is definitely a feature that is needed for anyone with a large database.

It would be nice if the old posts after a certian date were written to htm files and taken out of the database. I don't care about disk space but DB space comes with a big price..

Thanks!

RE: Discussion: Forum Archiving

Mark Christianson — Tue, 28 Feb 2006 18:31:45 GMT

... you wait quietly and occationally bug the hell out of Ryan to get him to look into it. At 500mb I would really like to slim things down.

RE: Discussion: Forum Archiving

eschlange — Mon, 27 Feb 2006 21:31:41 GMT

I think archiving is a great feature (good ol' Snitz...)--does IF not support it? If not, what do you do after your database gets too big?

_eric

Discussion: Forum Archiving

Mark Christianson — Wed, 14 Dec 2005 06:36:34 GMT

I would like to open the discussion on how IF can best handle archiving of old posts/data etc.

I have a forum that currently holds a few years of data and frankly at 450-500mb its time to put my active topics/posts on a diet.

First, I think that much like the Snitz forum of which I had previous experience I liked that the archive function pushed data from a date the admin would choose back. to a matching set of tables [tablename]_archive. This allowed the users to still have access to the old data via search (advanced search provides a checkbox button to search active and archive or just one or the other).

The advantages should be clear... less table data in the primary tables leads to greater performance since there is less data to cull.

Since I know others have been using other forums I would like to know what other strategies you think would be good for archiving in IF