|
|
 Posted 14/12/2005 06:36:34 |
|
|
Supreme Being
Group: Moderators
Last Login: 14/10/2008 15:36:31
Posts: 582,
Visits: 876
|
|
| 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
Mark 'Rigger82' Christianson
US Paratrooper & Webmaster of Paratrooper.net
http://www.paratrooper.net
|
|
|
|
| Posted 27/02/2006 21:31:41 |
|
|
Forum Newbie
Group: Forum Members
Last Login: 03/03/2006 17:13:19
Posts: 15,
Visits: 27
|
|
| 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
|
|
|
|
| Posted 28/02/2006 18:31:45 |
|
|
Supreme Being
Group: Moderators
Last Login: 14/10/2008 15:36:31
Posts: 582,
Visits: 876
|
|
... 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.
Mark 'Rigger82' Christianson
US Paratrooper & Webmaster of Paratrooper.net
http://www.paratrooper.net
|
|
|
|
| Posted 12/11/2006 22:00:46 |
|
|
Forum Newbie
Group: Forum Members
Last Login: 12/11/2006 21:55:21
Posts: 1,
Visits: 3
|
|
| 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!
Steve Sinchak
TweakXP.com
TweakVista.com
Tweaks.com
|
|
|
|
| Posted 14/11/2006 11:10:20 |
|
|
Supreme Being
Group: Customers
Last Login: 22/09/2008 15:59:25
Posts: 693,
Visits: 2,418
|
|
Agreed on all things stated above  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 
..:: Bare ::..
http://www.livingformetal.com
|
|
|
|
| Posted 17/11/2006 06:21:16 |
|
|
Supreme Being
Group: Moderators
Last Login: 14/10/2008 15:36:31
Posts: 582,
Visits: 876
|
|
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.
Mark 'Rigger82' Christianson
US Paratrooper & Webmaster of Paratrooper.net
http://www.paratrooper.net
|
|
|
|
| Posted 17/11/2006 14:02:15 |
|
|
Junior Member
Group: Forum Members
Last Login: 21/09/2008 17:12:17
Posts: 22,
Visits: 56
|
|
| 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
Horsham Forum | Visit Horsham | Virtual Horsham
|
|
|
|