Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Slow forum and error while compacting db
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Slow forum and error while compacting db
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
pvillaca View Drop Down
Newbie
Newbie


Joined: 03 June 2004
Status: Offline
Points: 34 		Post Options Post Options   Thanks (0) Thanks(0)   Quote pvillaca Quote  Post ReplyReply Direct Link To This Post Topic: Slow forum and error while compacting db
    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???
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 04 June 2004 at 4:57am
There isn't a mySQL version of the forum and as you are trying to compact the database I'm gussing you mean you are using the Access version of the forum.

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

However, with that many posts I would recommened that you move across to the MS SQL Server version as Access was never designed as a web database and uses allot of server resources.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
xeerex View Drop Down
Senior Member
Senior Member


Joined: 19 November 2002
Location: United States
Status: Offline
Points: 601 		Post Options Post Options   Thanks (0) Thanks(0)   Quote xeerex Quote  Post ReplyReply Direct Link To This Post 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.
Need Hosting, Domains, Dedicated Servers?
web design | pc support | training | podcasts | video production
Back to Top
pvillaca View Drop Down
Newbie
Newbie


Joined: 03 June 2004
Status: Offline
Points: 34 		Post Options Post Options   Thanks (0) Thanks(0)   Quote pvillaca Quote  Post ReplyReply Direct Link To This Post 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?
Back to Top
dpyers View Drop Down
Senior Member
Senior Member


Joined: 12 May 2003
Status: Offline
Points: 3937 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dpyers Quote  Post ReplyReply Direct Link To This Post 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.

Lead me not into temptation... I know the short cut, follow me.
Back to Top
dj air View Drop Down
Senior Member
Senior Member
Avatar

Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dj air Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
pvillaca View Drop Down
Newbie
Newbie


Joined: 03 June 2004
Status: Offline
Points: 34 		Post Options Post Options   Thanks (0) Thanks(0)   Quote pvillaca Quote  Post ReplyReply Direct Link To This Post 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!
Back to Top
xeerex View Drop Down
Senior Member
Senior Member


Joined: 19 November 2002
Location: United States
Status: Offline
Points: 601 		Post Options Post Options   Thanks (0) Thanks(0)   Quote xeerex Quote  Post ReplyReply Direct Link To This Post 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
%>
Need Hosting, Domains, Dedicated Servers?
web design | pc support | training | podcasts | video production
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.