Web Wiz Support and Community Forums : Slow forum and error while compacting db https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 12:48:55 +0000 Sat, 05 Jun 2004 12:42:51 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=10722 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Slow forum and error while compacting db : xeerex wrote:Of course, I close...]]> https://forums.webwiz.net/slow-forum-and-error-while-compacting-db_topic10722_post58910.html#58910 Author: xeerex
Subject: 10722
Posted: 05 June 2004 at 12:42pm

Originally posted by xeerex xeerex wrote:

Of course, I close the forum,...

Sorry but I thought that was obvious.

One thing to consider is that even by locking the forum, the database still gets a connection each time someone hits the board since the lock is using the database. I understand the administrative ease and reason that -borg- has the lock in the database; however, on really active boards you may consider using a script that will "lock" users and redirect them without using a database connection.

For instance, I created a "lock.asp" file and just include it in any pages that may make a database connection. I manually change the page to "locked" and FTP it to the site. I make all necessary changes, "unlock" the page, and FTP it up again.

<%
'Lock access to the Admin Module
strLocked = "No"  'Change this to yes or no
If strLocked = "Yes" Then
 Response.Redirect("Lock_Message.asp")
End If
%>

]]> Sat, 05 Jun 2004 12:42:51 +0000 https://forums.webwiz.net/slow-forum-and-error-while-compacting-db_topic10722_post58910.html#58910 <![CDATA[Slow forum and error while compacting db : dpyers wrote:Try locking the...]]> https://forums.webwiz.net/slow-forum-and-error-while-compacting-db_topic10722_post58846.html#58846 Author: pvillaca
Subject: 10722
Posted: 04 June 2004 at 8:44pm

Originally posted by dpyers dpyers wrote:

Try locking the forum before doing an Access compact and repair. Sound's like there may be activity updating the ldb file which has been known to cause a C&R to fail and lock things up.

That worked like a charm. :)

Thanks!

]]> Fri, 04 Jun 2004 20:44:35 +0000 https://forums.webwiz.net/slow-forum-and-error-while-compacting-db_topic10722_post58846.html#58846 <![CDATA[Slow forum and error while compacting db : the way to tell if you are using...]]> https://forums.webwiz.net/slow-forum-and-error-while-compacting-db_topic10722_post58836.html#58836 Author: dj air
Subject: 10722
Posted: 04 June 2004 at 5:46pm

the way to tell if you are using an access version or an SQL version is 2 ways

1. have you got a database which you dont require a username and password to conect to (if so you are using an Access database),

did you have to run the page (msSQL_server_setup.asp)? if so you are running an SQL version

2. Go into the admin area and if you are running the SQL version in the menu you will be able to go to a page that gives some SQL server details like the size of the SQL database and the log file. if so you are using an SQL version.



Edited by dj air]]> Fri, 04 Jun 2004 17:46:48 +0000 https://forums.webwiz.net/slow-forum-and-error-while-compacting-db_topic10722_post58836.html#58836 <![CDATA[Slow forum and error while compacting db : Try locking the forum before doing...]]> https://forums.webwiz.net/slow-forum-and-error-while-compacting-db_topic10722_post58829.html#58829 Author: dpyers
Subject: 10722
Posted: 04 June 2004 at 3:29pm

Try locking the forum before doing an Access compact and repair. Sound's like there may be activity updating the ldb file which has been known to cause a C&R to fail and lock things up.]]> Fri, 04 Jun 2004 15:29:12 +0000 https://forums.webwiz.net/slow-forum-and-error-while-compacting-db_topic10722_post58829.html#58829 <![CDATA[Slow forum and error while compacting db : Well, sorry for the mistake about...]]> https://forums.webwiz.net/slow-forum-and-error-while-compacting-db_topic10722_post58826.html#58826 Author: pvillaca
Subject: 10722
Posted: 04 June 2004 at 2:14pm

Well, sorry for the mistake about the "MYSQL". However, I do believe I'm using the SQL version, not the Access one. HOw can I check this out?]]> Fri, 04 Jun 2004 14:14:02 +0000 https://forums.webwiz.net/slow-forum-and-error-while-compacting-db_topic10722_post58826.html#58826 <![CDATA[Slow forum and error while compacting db : Definitely time to go to SQL Server! As...]]> https://forums.webwiz.net/slow-forum-and-error-while-compacting-db_topic10722_post58809.html#58809 Author: xeerex
Subject: 10722
Posted: 04 June 2004 at 10:44am

Definitely time to go to SQL Server!

As a side note, I run an Access version that is currently at ~13MB with 7500+ users averaging over 25 active users at any one time. Page returns are generally less than .5 seconds; however, I had to work with my host to get my board to run that fast with that many connections to Access. At peak times, there will be over 100 active users showing and page returns are still less than 1 second.

I have noticed that when I use the Admin Compact/Repair it will error on the first try. I have to FTP into the site, delete the temp databases that are created, and then the C/R will work fine. Of course, I close the forum, and I could download the database and "manually" C/R; however, I make a daily backup of the database to my local computer anyway so any lose would not be that great.

]]> Fri, 04 Jun 2004 10:44:11 +0000 https://forums.webwiz.net/slow-forum-and-error-while-compacting-db_topic10722_post58809.html#58809 <![CDATA[Slow forum and error while compacting db : There isn&#039;t a mySQL version...]]> https://forums.webwiz.net/slow-forum-and-error-while-compacting-db_topic10722_post58789.html#58789 Author: WebWiz-Bruce
Subject: 10722
Posted: 04 June 2004 at 4:57am

There isn't a mySQL version of the forum and as you are trying tocompact the database I'm gussing you mean you are using the Accessversion of the forum.

To compact and repair the database try downloading the database andopening it in Access and use the Compact and repair tool from theTolols menu.

However, with that many posts I would recommened that you move acrossto the MS SQL Server version as Access was never designed as a webdatabase and uses allot of server resources.
]]> Fri, 04 Jun 2004 04:57:38 +0000 https://forums.webwiz.net/slow-forum-and-error-while-compacting-db_topic10722_post58789.html#58789 <![CDATA[Slow forum and error while compacting db : Dear friends, well, before explaining...]]> https://forums.webwiz.net/slow-forum-and-error-while-compacting-db_topic10722_post58777.html#58777 Author: pvillaca
Subject: 10722
Posted: 03 June 2004 at 8:01pm

Dear friends,

well, before explaining my problem, I must say I'm a HUGE fan of WWForum, which I use since last December.

Recently, my forum started to run really slowly. I batch deleted old topics, deleted 400+ registered users that have never posted, but no dice. It's still slow. My forum statistics (after deleting topics and members):

82119 mensagens em 2847 Tópicos em 31 Fórum(s)
Nós temos 1445 Membros do fórum

My database is 142 Mb. I run the MySQL version of the forum. WHen I try compacting the DB, I get the following message:

Database backed up to:-
C:\Inetpub\CinemaCena\forum\admin\database\ccForum-backup.md b

Microsoft JET Database Engine error '80004005'

Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt.

/cinemacena/forum/admin/compact_access_db.asp, line 124

 

What can I do???

]]> Thu, 03 Jun 2004 20:01:15 +0000 https://forums.webwiz.net/slow-forum-and-error-while-compacting-db_topic10722_post58777.html#58777