Print Page | Close Window

Getting VERY SLOW!!

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=4903
Printed Date: 02 April 2026 at 2:39pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Getting VERY SLOW!!
Posted By: drclive
Subject: Getting VERY SLOW!!
Date Posted: 10 August 2003 at 8:52am

I have had my forums running for about a year now.

http://www.cubafar.com/forum/ - http://www.cubafar.com/forum/

Last week I had to download the DB locally and compact and fixed with access because It was so slow that I got script time out.

I did try to migrate to 7.0 but when I did the database migration the new forum didn’t show any of the static and what was worst it had some crash when I try to insert new post. A reference problem I guess. Any way the migration couldn’t happen.

Now I’m still running 6.34 and I’m not getting script time out after I did compact the DB but is still very slow. Anybody could help me to fix this problem?

Thanks in advance.



-------------
DrClive



Replies:
Posted By: MadDog
Date Posted: 10 August 2003 at 9:55am
its probably slow because you are using an access database and its gotten really big.

-------------
http://www.iportalx.net" rel="nofollow">


Posted By: Nigelo
Date Posted: 10 August 2003 at 12:50pm

No, it does not look like a large Access DB problem - Judging by the number of Threads, Posts and Members it is several times smaller than mine which runs perfectly well at a shade over 10Mb. To me, it looks like a server problem (since the site itself is slow to load) that may just require a simple reboot so have a word with your Host.

Concerning the migration, you MUST perform a compact/repair on the old 6.34 AND the empty new v7 BEFORE running the migrator. After migration perform another compact/repair on the newly populated v7 DB. The stats will require resychronising which Borg has provided using the Admin facility once installed.



-------------
Hope this helps
Nigel


Posted By: cookh
Date Posted: 10 August 2003 at 1:24pm

Please repair and compact your data base. If you want to upgrade to 7.1 do the same befor conversion and after.

You can find the "Re-sync Topic and Post Count" function in the administration page.

Good luck!



Posted By: Bliss
Date Posted: 10 August 2003 at 2:33pm
10 mb is considered large for access. Access can be depended on until it reaches about 7 mb, and then it gets unreliable, and gets slow or crashes a lot.


Posted By: Nigelo
Date Posted: 10 August 2003 at 4:16pm

As I said, not on my site - No crashes whatsoever and still as fast as ever, with regular compaction of course. If the design is good and the DB properly maintained, there is no reason why it should suddenly fail above 7MB. Proof is mine hasn't.

 



-------------
Hope this helps
Nigel


Posted By: ljamal
Date Posted: 10 August 2003 at 5:18pm
It's not going to suddenly fail, but it will require more and more maintenance and perform poorer and poorer until the performance is no longer acceptible.

-------------
L. Jamal Walton

http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming


Posted By: God_Struth
Date Posted: 10 August 2003 at 5:40pm

I have an access database running the version 7 of the forum and never have any trouble with it, not even speed issues.

What size is the database I hear you ask?

 

89.2mb!

 

Never been compacted other than the switch from 6.4



Posted By: Bunce
Date Posted: 10 August 2003 at 5:46pm

Originally posted by Bliss Bliss wrote:

10 mb is considered large for access. Access can be depended on until it reaches about 7 mb, and then it gets unreliable, and gets slow or crashes a lot.

Where in the world do people get these numbers from!



-------------
There have been many, many posts made throughout the world...
This was one of them.


Posted By: Bliss
Date Posted: 10 August 2003 at 6:57pm
Experience.


Posted By: WebWiz-Bruce
Date Posted: 11 August 2003 at 2:30am

The size you can run an access database depends on a number of things.

As Access was not designed to be a web backend database system and as it is a flat file database the performance of it when used for web applications is not great.

If you are on your own dedicated server with no other sites on the server and a powerful server than you can have quite large access databases.

If you are on a shared server than depending on the power, memery available and the number of sites on the server 10mb can be considered very large, as each time someone connects to the forum the whole 10mb file needs to be loaded into memory. If the server is busy, or if someone on the server is using bad programming and has eaten up allot of the server memory then the forum with an access database will run slow and give timeout errors as it takes quite allot of server resources to open an access database using the JET database drivers form an asp application.

If you find that your forum runs slow with access then you have two choices, get a dedicated server, or switch to SQL server. I would go for the SQL srever as it is much cheaper.



-------------
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: cookh
Date Posted: 11 August 2003 at 6:13am

I'm using Access version and the database is 7.5MB now. Though the forum is runing well till now, I'm thinking about tranfer it to the SQL version.

Can you tell me where can I get the tool for migration? I searched on this web site but no luck.

Thanks!



Posted By: WebWiz-Bruce
Date Posted: 11 August 2003 at 6:46am

There is no migration tool, but you can use the upsize wizard in Access to upsize your database to SQL server, then run the SQL server serup file found in the SQL server version to create the stored procedures.

You will get a few errors come up when running this file as most of the tables will be cerated by the upsize process, but just ingnore these.

Also you may find that extra admin and guest accounts and groups are cerated that you will need to delete from the admin area.



-------------
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: drclive
Date Posted: 11 August 2003 at 7:02am
Should I migrate the DB first from 6.34 to 7.01 and them the upsize wizard ?

-------------
DrClive


Posted By: WebWiz-Bruce
Date Posted: 11 August 2003 at 7:18am
Yes

-------------
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



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net