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

  New Posts New Posts RSS Feed - Big database problem (.ldb servertimeout)
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Big database problem (.ldb servertimeout)
 Post Reply Post Reply Page  123>
Author
  Topic Search Topic Search  Topic Options Topic Options
NeutralizeR View Drop Down
Newbie
Newbie


Joined: 14 December 2004
Location: Turkey
Status: Offline
Points: 35 		Post Options Post Options   Thanks (0) Thanks(0)   Quote NeutralizeR Quote  Post ReplyReply Direct Link To This Post Topic: Big database problem (.ldb servertimeout)
    Posted: 17 February 2005 at 8:47pm
Hello.
 
I'm using Web Wiz Forums v7.9 for 3 months.
 
I've 1600+ members and 13000+ posts at my forum,
 
and my access database file size is 21 MB, is it normal?
 
Everthing worked great until last week. Now, i have a big problem with my database (i guess)
 
Active Server Pages, ASP 0113 (0x80004005) The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools.
 
I've read all topics related to my problem before posting this...
 
My database created a (temp) .ldb file, and everthing freezes.
 
I can not connect to database... I can not compact & repair my database...
 
.ldb file is locked and it disappers 5 to 10 minutes later.
 
Then i can go to Admin panel....
 
Anyway...
 
I've one to one contact with my host, we tried every possible way to solve this problem but no success...
 
What should i do ?
 
Converting Access to SQL server is a solution?
 
My host supports:
 
* IIS v.5
* ASP.NET
* ASP
* PHP
* Perl
* CGI
* SQL 3.0
* MySql
* SSL
---
* CDONT
* Persist ASPE-Maıl
* Persist ASP Uploader
* Frontpage Server Extentions 
* ODBC/MDAC/UDA
 
My host changed  the server script timeout to 600... it worked for one day...
 
What's a permanent solution for this problem?
 
My forum URL:
 
 
Waiting help asap!
 
Thank you
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: 18 February 2005 at 5:44am
If you have even a slightly busy forum or an Access database over 10Mb I would change to SQL Server.

Access as a flat file database system just puts to much strain on the web server when used as a backend database for a forum.

I now have a comment on this on the forums download page, in the hope that more people start with SQL Server from the start to prevent these problems from occurring.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
NeutralizeR View Drop Down
Newbie
Newbie


Joined: 14 December 2004
Location: Turkey
Status: Offline
Points: 35 		Post Options Post Options   Thanks (0) Thanks(0)   Quote NeutralizeR Quote  Post ReplyReply Direct Link To This Post Posted: 18 February 2005 at 7:14am

I'm downloading Microsoft SQL Server 2000 Enterprise Edition now.

I haven't used it before. This will be my first install but your step by step guide looks easy...
 
After i convert my Access database to SQL Server,
 
Should i change my web wiz forum asp files, too?
 
Current one: Web Wiz Forums v7.9 Access version
 
Thanks for your help...
Back to Top
sfd19 View Drop Down
Senior Member
Senior Member


Joined: 20 December 2004
Status: Offline
Points: 263 		Post Options Post Options   Thanks (0) Thanks(0)   Quote sfd19 Quote  Post ReplyReply Direct Link To This Post Posted: 18 February 2005 at 7:16am
Originally posted by NeutralizeR NeutralizeR wrote:

Hello.
 
I'm using Web Wiz Forums v7.9 for 3 months.
 
I've 1600+ members and 13000+ posts at my forum,
 
and my access database file size is 21 MB, is it normal?
 
 
Our live database has 21.000 posts and its size is 67 MB, 62 MB for the table tblThread alone. (3 KB per post) So I would say that your DB size is quite normal. (1,5 KB per post).
 
The size depends very much on the average length of your members posts (and included quotes), lengthy posts and long quotes will increase the DB size above-average.
Politics, economy & social issues: StudentsforDemocracy.net
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: 18 February 2005 at 7:57am
sfd19, I suggest that you upgrade to SQL Server as soon as possible before you start getting problems.

Access database have a number of limitations including:-

  • Being a flat file database system, so the entire lot needs to be loaded into memory each time your forum is accessed
  • The ODBC connection pool only allows 20 concurrent connections per server
  • Limits on file size
  • Limits on connections, not just through ODBC
  • Often becomes corrupted and can not be recovered losing all data
  • Often is much larger file size than is required as data is never properly deleted until a compact and repair is run
  • Bad on performance
The list goes on.

So I suggest that anyone wanting to run a forum that has more than a handful of users should really use MS SQL Server, which doesn't have these limitations.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
NeutralizeR View Drop Down
Newbie
Newbie


Joined: 14 December 2004
Location: Turkey
Status: Offline
Points: 35 		Post Options Post Options   Thanks (0) Thanks(0)   Quote NeutralizeR Quote  Post ReplyReply Direct Link To This Post Posted: 18 February 2005 at 7:59am
Hmm... Okay...
 
My Access database is quite normal.
 
I've been using some mods (latest forum posts, today's visitors etc.) and i removed latest forum posts from default.asp and my forum worked for a while... I tried to make a search in message body, then it stopped working again...
 
Trying to convert to SQL Server...
 
Hope this is the solution...
 
Thanks


Edited by NeutralizeR - 18 February 2005 at 8:14am
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: 18 February 2005 at 8:15am
SQL Server is much more robust, this site currently has around an 80Mb SQL Server database and over 70,000 topics by 7,000 members.

I'm currently working on improving performace for version 8 and on a test of using an array on the memberslist, instead of ADO paging, on this site I increased performance by 3000% from over 4 seconds for page processing for 7,500 members to 0.2 seconds.

I hope to beable to do the same for allot of the other pages, including the main forum page, topic pages, and post pages.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
sfd19 View Drop Down
Senior Member
Senior Member


Joined: 20 December 2004
Status: Offline
Points: 263 		Post Options Post Options   Thanks (0) Thanks(0)   Quote sfd19 Quote  Post ReplyReply Direct Link To This Post Posted: 18 February 2005 at 9:52am
Originally posted by -boRg- -boRg- wrote:

sfd19, I suggest that you upgrade to SQL Server as soon as possible before you start getting problems.

Access database have a number of limitations including:-

  • Being a flat file database system.....................

Thanks Borg, though I am absolutley aware of all the limitations of an Access DB.

But we have heavily altered much of the original WWF/EzASPSite code, have added lots of features, files, tables, databases and more. I doubt that there exists a file that has not been altered at all.
 
The time consumption for making the entire code SQL-ready would be enormous.
 
What I did was creating an archive where all older topics get moved into. That reduced the original size of the DB from 130 MB to ~60 MB, and with that feature I can keep the 'live' DB size at 50-70 MB while the archive DB size does not matter so much, since it gets not accessed frequently. Also the archive DB can not get corrupted since it is read-only and changes are only made every few months when I am archiving more topics. That also makes a frequent backup of the archive unnecessary.
 
SQL would of course be the way to go, but not only the time for all the code changes but also the the money that would be required to host it on SQL/ASP-webspace (15+ GB traffic, 750+ MB webspace, at least 200 MB SQL) makes it impossible. Cry
Politics, economy & social issues: StudentsforDemocracy.net
Back to Top
 Post Reply Post Reply Page  123>

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.