how good does webwiz run using access
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=8171
Printed Date: 29 March 2026 at 3:37pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: how good does webwiz run using access
Posted By: edibdi
Subject: how good does webwiz run using access
Date Posted: 17 December 2003 at 3:04pm
| I'm curious as to how well webwiz runs using an access database. Is there slow down. How many people can be logged on at the same time and it run well. I've been playing with phpbb using mysql and was curious how it will run vs webwiz usiing access. |
Replies:
Posted By: Gullanian
Date Posted: 17 December 2003 at 4:51pm
| I think mySQL will run better than access overall, but WWG with access runs 100% a-ok until you get thousands and thousands of posts |
Posted By: psycotik
Date Posted: 17 December 2003 at 5:41pm
|
Im running access version with approx 50k posts and 600 users (there is on average 5-15 users online at any one time during day). Havent really noticed any speed problems as of yet. |
Posted By: Gullanian
Date Posted: 17 December 2003 at 5:54pm
| You would notice a difference if you used ms sql though |
Posted By: pedigree
Date Posted: 17 December 2003 at 6:57pm
|
psycotik wrote:Posted By: india
Date Posted: 17 December 2003 at 11:16pm
well, im also running forum with 8000members and more than 40k posts.works fine. no probs till now |
Posted By: Joey805
Date Posted: 18 December 2003 at 11:39am
| This forum wont run on mysql only MSSQL. |
Posted By: Badaboem
Date Posted: 18 December 2003 at 12:14pm
|
It depends highly on the server you use. I'm running access: Integrated download directory into the forum database. Around 130 downloads with image links and text stored in database. |
Posted By: thekiwi
Date Posted: 18 December 2003 at 12:39pm
|
It depends. Checkout http://www.aspfaq.com/show.asp?id=2195 - http://www.aspfaq.com/show.asp?id=2195 and you will see there is no definite answer ... other than "you will have problems", be it with concurrent users, large databases, X no. of records etc etc ------------- Cheers TheKiwi http://www.infobahn.co.nz - Internet Infobahn - website design and hosting |
Posted By: psycotik
Date Posted: 19 December 2003 at 7:34pm
Same for me. No corruption. Works a treat. |
Posted By: JohnKn
Date Posted: 02 January 2004 at 2:57am
How large are your databases? I've only had mine running for a couple weeks, version 7.6, and the db is already 3.9 meg with only 2,000 posts and 1,100 members. At this rate I'll be at 100 meg at 50k posts, is that what you're seeing? |
Posted By: india
Date Posted: 02 January 2004 at 3:37am
|
Well, i divided my forum into 2. the old one 40k++ posts n 8k++ members was 30mb ++ now , new one since 1month, 3k++members, mayb 5k++ posts, db is 6mb |
Posted By: JodoHost
Date Posted: 20 January 2004 at 11:08pm
|
I'm a strong supporter of SQL Server because I know what MS Access databases this big can do to the servers. MS Access is the number one problem causer for us. We've had to ask many customers to shift to other hosts because their MS Access database was putting a huge strain on the CPU or memory resources. MS Access isn't built for this type of load. You can find that straight out of Microsoft's website. SQL Server is built to handle thousands of data transactions a minute quickly and efficiently. You'll see a notable difference in speed if you switch to SQL Server as your backend |