| Author |
 Topic  |
|
|
James
Average Member
USA
539 Posts |
 Posted - 06 May 2001 : 01:56:13
|
I know that I asked this question before and someone replied that they were working on it, but I can't seem to find the post anywhere.
What I'd like is ASP code to compact the database, say something maybe added to the admin screens.
-
*Interested in Radio Control*
*The RC Web Board - http://www.rcwebboard.com/* |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 06 May 2001 : 02:12:23
|
This functionality is included in the latest alpha as part of the archiving feature.
I believe that the admin_compactdb.asp file (along with the down.asp file and a few modifications to inc_top.asp) could probably be used in your current forum.
You can get the latest alpha here: http://forum.snitz.com/alpha.asp
be sure to backup your database first just in case. |
 |
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 06 May 2001 : 03:27:02
|
Richard, is correct, the admin_compactdb should work on it's own, the down.asp is required to close your forum down, as are the changes to inc_top etc, if you nknow you have a quiet time with no db access, you could do it without making the changes for down.asp, You must close your site in some way, if someone tries to access it while the db is compacting, could have bad results.
Thecompact asp file also backsup your db first.
|
|
|
|
bjlt
Senior Member
1144 Posts |
Posted - 06 May 2001 : 05:39:51
|
will the new archiving be able to use the origiginal ID to find an archived topic, and search archive?
I know Huwr is working on that, just wonder when it will come out.
thanks
|
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 06 May 2001 : 06:39:26
|
Yes, the search screen will have a checkbox which will allow you to search the archives, link.asp works as now except if it does not find the topic, it then checks the archive. (so any current links in messages will still work)
There will also be a link on forum.asp to the archived topics.
I am currently spending a couple of days testing it's integration, and a new release should be forthcoming soon.
|
|
|
|
James
Average Member
USA
539 Posts |
Posted - 06 May 2001 : 22:39:29
|
Ok, going to d/l it now. I imagine as a quick fix, I can rename my db and then run the compacting on it. Renaming it should cause the forum not to work until I change the name back, thus preventing any accesses to it, correct?
-
*Interested in Radio Control*
*The RC Web Board - http://www.rcwebboard.com/* |
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 07 May 2001 : 06:19:20
|
yes, that is a good way
|
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 07 May 2001 : 14:32:07
|
what is a good guideline for db maintenance such as this? I have 258 members and lots of modz applied which means lots of activity. should I compact (reindex) once a week or more? please advise... thanks.
Dayve |
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 07 May 2001 : 16:56:19
|
Compacting only makes sence if you delete a lot of topics, because it make the free open space that isn't autmatically reclaimed available again.
So if you only delete a few topics a week, you can limit compacting to once in a few months. The database will grow ofcourse because of the increasing number of topics/replies and even members, but the size occupied by them will still be the same after compacting.
With the amount of users you have, if the site really is active, you might consider switching to Sql Server instead anyhow.
Pierre
Join the Snitz WebRing |
|
|
| |
Topic |
|
Topic Locked
