Web Wiz Forums - WWF times out a lot after upgrade from 7.9 to 10

Print Page | Close Window

WWF times out a lot after upgrade from 7.9 to 10

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=30144
Printed Date: 31 March 2026 at 9:33pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: WWF times out a lot after upgrade from 7.9 to 10

Posted By: kpauli142
Subject: WWF times out a lot after upgrade from 7.9 to 10
Date Posted: 02 February 2012 at 5:23pm

Ever since I upgraded from WWF version 7.9 to 10 the forum has had issue with script timeouts that I can't explain. Has any one else had this issue or know how I can solve/investigate?

Thanks.

Replies:

Posted By: WebWiz-Bruce
Date Posted: 03 February 2012 at 6:37am

Version 10 performance wise is massively improved since version 7. If you are seeing time out issues then it points to resources issues with the server that you are using.

You did not say what database type you are using on the exact time out message so it is hard to pinpoint further for you where you should be looking.

-------------
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: kpauli142
Date Posted: 03 February 2012 at 9:26pm

Sorry I am using an Access database. I'll wave to wait until it times out again to get you the exact mesasge. The database size is about 250MB now if that matters. Any help is appreciated. Thanks.

Posted By: kpauli142
Date Posted: 06 February 2012 at 2:22am

At this point I'm assuming I'll need to convert my Access database to MySQL since I've been reading that an Access database of this size should not be used. Although I'm still confused as to why it seemed OK with the old WWF version 7.9. Some questions:

1) Which of the Access to MySQL converters has been proven to work well with WWF?

2) Is there a way to estimate what the file size will be of the MySQL converted database?

3) Is there an easy way to tell WWF to use the new MySQL database instead of the old Access one?

Thanks again for the help

Kurt

Posted By: WebWiz-Bruce
Date Posted: 06 February 2012 at 8:58am

Your Access database is far to large and would cause issues.

Access and SQL Server versions use a Relational Database Schema and use very similar data types. mySQL is not a Relational Database and so uses a different schema and it also has very different data types.

We also tend to find that the myODBC driver required for Cliassic ASP to connect to mySQL can be very buggy and throw some strange errors. We also tend to find mySQL falls over when getting to around 300MB and becomes corrupted quite often.

For the reasons mentioned above you would need to upsize your Access database to SQL Server.

If you wanted to use mySQL then you would need to start with a fresh install of Web Wiz Forums.

Posted By: kpauli142
Date Posted: 06 February 2012 at 1:42pm

OK thanks a lot. So I still have the questions:

1) Which of the Access to SQL Server converters has been proven to work well with WWF?

2) Is there a way to estimate what the file size will be of the SQL Server converted database (to know how large a database my hoster allows)?

3) Is there an easy way to tell WWF to use the new SQL Server database instead of the old Access one?

Posted By: WebWiz-Bruce
Date Posted: 06 February 2012 at 3:25pm

The Upsize Wizard in MS Access works fine for upsizing most Access database, although it sometimes has issues with larger databases over 150MB. Make sure you compact and repair the database in MS Access before you do the upsize.

There is no way to tell the size of the database after the upsize, but generally you would use around 125MB to 175MB for each 100,000 posts. You should shrink the SQL Server Database after upsizing as this will greatly reduce the overall size.

Once you have upsized the Access database to SQL Server re-install Web Wiz Forums, select the database version of Web Wiz Forums you have and then select SQL Server from the list of database types. The install wizard will then set the correct settings for the type of database that you are using.