Big database problem (.ldb servertimeout)
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=13870
Printed Date: 02 April 2026 at 12:59pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Big database problem (.ldb servertimeout)
Posted By: NeutralizeR
Subject: Big database problem (.ldb servertimeout)
Date 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:
http://www.MsXLabs.com/forum - http://www.MsXLabs.com/forum
Waiting help asap!
Thank you ------------- http://www.MsXLabs.com"> 
|
Replies:
Posted By: WebWiz-Bruce
Date 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. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: NeutralizeR
Date 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... ------------- http://www.MsXLabs.com">
|
Posted By: sfd19
Date Posted: 18 February 2005 at 7:16am
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: http://www.studentsfordemocracy.net - StudentsforDemocracy.net |
NeutralizeR wrote:Posted By: WebWiz-Bruce
Date 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:-
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. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: NeutralizeR
Date 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 ------------- http://www.MsXLabs.com">
|
Posted By: WebWiz-Bruce
Date 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. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: sfd19
Date Posted: 18 February 2005 at 9:52am
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.  ------------- Politics, economy & social issues: http://www.studentsfordemocracy.net - StudentsforDemocracy.net |
Posted By: dpyers
Date Posted: 18 February 2005 at 9:52am
|
You might also want to try doing a compact and repair against the access db.
Then shut the forum down and delete any left over .ldb files before restarting it.
Your ultimate solution though is MS SQL. ------------- 
Lead me not into temptation... I know the short cut, follow me. |
Posted By: NeutralizeR
Date Posted: 18 February 2005 at 10:02am
|
I've succesfully converted my Access database to SQL Server.
I've made the required changes such as
'Database Type
'strDatabaseType = "Access" strDatabaseType = "SQLServer" in both common.asp files...
Then i edited the sections below:
'Enter the details of your SQL server below
strSQLServerName = "WEBSRVR" 'Holds the name of the SQL Server strSQLDBUserName = "my name" 'Holds the user name (for SQL Server Authentication) strSQLDBPassword = "my pass" 'Holds the password (for SQL Server Authentication) strSQLDBName = "my database" 'Holds name of a database on the server i go to http://www.msxlabs.com/forum - http://www.msxlabs.com/forum
it says the forum is closed... it's ok...
then i go to http://www.msxlabs.com/forum/admin - http://www.msxlabs.com/forum/admin
trying to login with my id but it says HTTP 500 error..
is it a database connection problem ???
what should i do...
i've tried several alternative server names... localhost, WEBSRVR, direkt ip....
:( what's wrong ? ------------- http://www.MsXLabs.com">
|
Posted By: WebWiz-Bruce
Date Posted: 18 February 2005 at 10:06am
|
I get the same error at both pages:- Microsoft OLE DB Provider for SQL Server error '80040e4d'
Login failed for user 'NeutralizeR'. Looks like a login problem at the sql server. You may need to turn off friendly HTTP error messages if you use IE ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: NeutralizeR
Date Posted: 18 February 2005 at 11:47am
|
Ok... My new SQL Database is working now.
I can login as admin and see the statistics vs...
But i can't make any changes...
I'd locked my forum when it was Access...
New SQL Server is locked, too...
how can i unlock it again ? it doesn't let me to do this...
Everytime i try to change something http 500 error occurs... ------------- http://www.MsXLabs.com">
|
Posted By: WebWiz-Bruce
Date Posted: 18 February 2005 at 12:02pm
|
You need to turn off friendly HTTP errors in IE, then the error message will help find what the problem is.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: NeutralizeR
Date Posted: 18 February 2005 at 12:07pm
|
Microsoft OLE DB Provider for SQL Server error '80004005' The cursor does not include the table being modified or the table is not updatable through the cursor. /forum/admin/close_forums.asp, line 89 ------------- http://www.MsXLabs.com">
|
Posted By: WebWiz-Bruce
Date Posted: 18 February 2005 at 12:20pm
|
This means that the method you used to upsize your database from Access to SQL Server has not worked.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: NeutralizeR
Date Posted: 19 February 2005 at 8:36am
Stored Procedures ? What's it ? ------------- http://www.MsXLabs.com">
|
Posted By: WebWiz-Bruce
Date Posted: 19 February 2005 at 9:51am
|
Stored prcedures are what will be created under stored procedures on the sql server when using the sql server setup file. The SQL Server version requires stored procedures to run and are for extra performance. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: NeutralizeR
Date Posted: 19 February 2005 at 10:47am
|
Microsoft OLE DB Provider for SQL Server error '80040e37' Invalid object name 'tblConfiguration'. /forum/admin/common.asp, line 320 new error message after i converted my access db to sql server... (2nd time)------------- http://www.MsXLabs.com">
|
Posted By: NeutralizeR
Date Posted: 19 February 2005 at 11:06am
|
i runned msSQL_server_setup.asp and the forum worked again.
then i went to admin panel, loginned with my id...
tried to unlock the forum and the error message was the same:
Microsoft OLE DB Provider for SQL Server error '80004005' The cursor does not include the table being modified or the table is not updatable through the cursor. /forum/admin/close_forums.asp, line 89 Is there anyone who can convert my access database to SQL server?
i can give you the required infos... username, pass, the mdb file etc...
Thanks... ------------- http://www.MsXLabs.com">
|
Posted By: WebWiz-Bruce
Date Posted: 19 February 2005 at 11:16am
|
Sorry I can not help as my ISP has blocked the ports required for me to
be able to connect to an SQL Server on home user accounts and I can't
afford the £100 admin fee and extra £30 a month to change to their business
account where they don't block these ports.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: NeutralizeR
Date Posted: 21 February 2005 at 9:17am
|
Finally i did it. Converted my old Access database to SQL Server database by trying several methods in Enterprise Manager (DTS Import/Export) Thank you… http://www.msxlabs.com/forum - http://www.MsXLabs.com/forum It’s working now… ------------- http://www.MsXLabs.com">
|
