homepage Welcome to WebmasterWorld Guest from 54.242.241.20
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / WYSIWYG and Text Code Editors
Forum Library, Charter, Moderator: open

WYSIWYG and Text Code Editors Forum

    
How much traffic can a FP2002/Access database handle?
People tell me not much and to go with PHP/MySQL
DeValle

10+ Year Member



 
Msg#: 958 posted 12:59 am on Dec 3, 2004 (gmt 0)

I use Dreamweaver but I have a copy of FrontPage 2002. I've never used it. However, I noticed that you can create a database using a FP wizard and its Access capability. Sounds like a real easy way to whip out a database driven site.

Problem is, a friend who says he knows what he's talking about tells me that an Access database won't handle much traffic at all.

Is that true? Just how much traffic can it handle? How many different users at the same time?

And are there any other problems anybody has experienced using this functionality?

 

Corey Bryant

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 958 posted 3:53 am on Dec 3, 2004 (gmt 0)

MS Access was never really built to handle a website. We have thrown a great number of concurrent users against an MS Access database without any problems. This might help you though:
[databasezone.com...]

-Corey

DeValle

10+ Year Member



 
Msg#: 958 posted 1:09 pm on Dec 3, 2004 (gmt 0)

Thanks, Corey.

I see from the table that the maximum concurrent users is listed as 255. That would be acceptable for a site built for a relatively small organization, such as I'm thinking about.

You said that you had thrown a lot of concurrent users at an Access db. You were talking about a web-based db, weren't you?

And the maximum concurent user limit brings up more questions:

a) What happens when the site gets overloaded? I don't know databases but I assume what we're talking about here is essentially a denial of service effect. Will the database just lock up or will the whole site crash?

b) If that site is a virtual host on a shared server, will that crash the other virtual hosts?

Corey Bryant

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 958 posted 1:20 pm on Dec 3, 2004 (gmt 0)

We had about 1,000 concurrent users at one time with no problems. I would not recommend this of course

The database wil typically stop responding. It might become corrupt. It might stop the server, depends on the server, etc.

Usually though, if your site is this busy, it does warrant SQL hosting

-Corey

DeValle

10+ Year Member



 
Msg#: 958 posted 1:45 pm on Dec 3, 2004 (gmt 0)

I think I'll give it a shot. As I say, for a fairly small trade association Access should handle it. And you can't beat the convenience, seamless and all that.

Thanks.

Corey Bryant

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 958 posted 2:04 pm on Dec 3, 2004 (gmt 0)

This is true. Plus it is very simple to upsize once it is done. Make sure tht you connection string is in one file just in case you are ready to upsize.

-Corey

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / WYSIWYG and Text Code Editors
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved