| Author |
 Topic  |
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
 Posted - 04 July 2002 : 18:40:00
|
Archives a great feature IMO, enables you to wipe a forum clean yet retain all the old posts still.
I search the archives here always if I'm looking for something. thing is people like myself who probably read 90% or more of the posts made here can remember seeing 'something' about a paricular issue or problem so go straight to the search screen. New people coming along to the forum generally just think they're the first person to hit such a problem and post without searching at all.
www.daoc-halo.com |
 |
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 04 July 2002 : 22:11:32
|
quote:
Why do we bog down our server and hinder its performance by keeping 100's of thousands of posts in an archive when nobody bothers to use it.
Actually how does it hinder performance if its not used ? thats almost an oxymoron ;) ... Apart from using some space I can't really think of performance issues with it. Theres one issue on default.asp where every category it goes out to see if theres any archive posts on it so it can display the icon which can be cleaned up and turned into a single call, but what else am I missing here ? Call me thick if ya want I just dont get it :)
www.daoc-halo.com |
|
|
|
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 05 July 2002 : 00:49:52
|
well i search the archies once in awhile. the only thing i hate is i do a search, and i dont get what im looking for, then i have to do another search to just search the archive forums. if there was a way to search both of them at the same time i think it would be much more useful.
Brad
Web Hosting with SQL Server @ $24.95 per month
|
|
|
|
snaayk
Senior Member
USA
1061 Posts |
Posted - 05 July 2002 : 01:34:32
|
I'm with Gremlin, most of the time I search the Archives it's because I KNOW that I saw something come up. Or a bookmark I made is no longer valid I go to the archive section to look it up.
Perhaps a solution is to only archive certain forums. And delete the rest. This would delete a lot of unused space. I suppose this especially important if your getting to your host's SQL server limit and you don't want to buy more space !See ya' old posts!
|
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 05 July 2002 : 03:38:13
|
If you're considering deleting archived posts would you please zip up a backup and send it to me first?
I don't search them often but occasionally, and the posts there are a great resource I'd hate to lose.
======
Doug G
====== |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 05 July 2002 : 07:11:25
|
quote:
Actually how does it hinder performance if its not used ? thats almost an oxymoron
Simply because of the space it takes, don't forget a SQL db still exists in a physical location, so the data has to be fetched in the same way a file is fetched, admittedly SQL is more efficient at doing this, but data is still spread around the 250Mb data file, so th large your db the more work it has to do,
I didn't say I was considerring deleting them, just trying to find out what peoples views on them are, since less than 1/2% of the 5000 daily visitors use the search page, admittedly it's better to have them archived than still in the main tables, but they account for a very large percentage of the total db size
|
|
|
|
Roland
Advanced Member
Netherlands
9335 Posts |
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 05 July 2002 : 09:55:17
|
quote:
but data is still spread around the 250Mb data file, so th large your db the more work it has to do,
Sort of, Indexes take the brunt of the workload and if youve got a good maintenance plan setup and are defragmenting indexes etc really your database could be 5 times as large and the performance difference would still be marginal. I dont think theres any indexes on the archive data by default though I guess you've already added some in there if not anyway :)
www.daoc-halo.com
Edited by - Gremlin on 05 July 2002 09:56:21 |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 05 July 2002 : 10:19:42
|
quote:
quote:
but data is still spread around the 250Mb data file, so th large your db the more work it has to do,
Sort of, Indexes take the brunt of the workload and if youve got a good maintenance plan setup and are defragmenting indexes etc really your database could be 5 times as large and the performance difference would still be marginal. I dont think theres any indexes on the archive data by default though I guess you've already added some in there if not anyway :)
www.daoc-halo.com
Edited by - Gremlin on 05 July 2002 09:56:21
I am not specifically talking of indexes/db performance, but rather the underlying architecture, which does make a vast difference as the databases get larger, which is why high powered SQL servers have dtabases mapped across several different physical drives, and I don't mean raid or striping, because of the performance gains from splitting your db this way, this is even more noticeable if your db is not a fixed size, but set to grow as your data expands, much the same as your windows paging file does.
A db index is just a map, just because they are kept clean and up to date, doesn't prevent the data being spread all over the place, just that the index knows where to find it.
|
|
|
|
bjlt
Senior Member
1144 Posts |
Posted - 05 July 2002 : 12:32:39
|
I think a feature of selected or featured posts would be useful. adm/mod can mark a topic as featured and they'll be archived in a featured topics table.
or there're better ways of doing similar things. just an idea.
|
|
|
|
VodkaFish
Average Member
USA
654 Posts |
Posted - 05 July 2002 : 12:37:25
|
Just to chime in, I use the archive if possible. Before I ask questions, I always search, and then archive search, then post. As someone else already pointed out, sometimes it's hard to hit the right keywords, but that's true with any search feature. Even though it may slow down things a tad, those .5% of questions that get answered may be worth it time-wise. On one of my forums, the archive feature is great. I'd like a way to reference the posts, but need them all closed and moved as my forums are seasonal. It's very efficient. I'm sure that's specific to each forum, but I don't mind the bulk.
v ø d k â f ï § h |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 07 July 2002 : 00:37:31
|
Yes putting DB filegroups on separate disks can help though I'd normally not bother with a DB so small as a couple of hundred meg.
Moving the archives into a separate table may be a better solution for this forum.
www.daoc-halo.com |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 07 July 2002 : 10:56:50
|
quote:
Yes putting DB filegroups on separate disks can help though I'd normally not bother with a DB so small as a couple of hundred meg.
[quote]
Well you should try it, unless you only have one db, then it won't help, but merely putting the two db's on seperate drives makes quite a big difference, regardless of their size
[quote]
Moving the archives into a separate table may be a better solution for this forum.
They already are, and like I said, I am talking about sytem architectur not database table design.
|
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 07 July 2002 : 19:58:57
|
quote:
Moving the archives into a separate table may be a better solution for this forum.
Table should read Database.
www.daoc-halo.com |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 07 July 2002 : 22:40:39
|
quote:
Table should read Database.
www.daoc-halo.com
Yes, something I am thinking about.
|
|
|
|
Topic |
|
Topic Locked
