Access on the web

[Tony S]

As a filemaker devolper this is a strange place to be
but I have a question.
We have had a web site devolped which is using MS access,
the web designer has advised us that as we are getting near to
5000 hits daily, and wil be be possibly getting maybe 50 orders a day
that Access is likely to fall over under the load, and crash, so he
will need to re-devolp the site with a more robust database.
Your experienced comments please!!

Many thank in advance

Tony

[Tony S]

On Sun, 14 Sep 2003 13:05:55 GMT, "rkc"
<rk*@yabba.dabba.do.rochester.rr.com> wrote:

"Tony S" <To**@powellprint.co.uk> wrote in message
news:vt********************************@4ax.com.. .

As a filemaker devolper this is a strange place to be
but I have a question.
We have had a web site devolped which is using MS access,
the web designer has advised us that as we are getting near to
5000 hits daily, and wil be be possibly getting maybe 50 orders a day
that Access is likely to fall over under the load, and crash, so he
will need to re-devolp the site with a more robust database.
Your experienced comments please!!

Is that 5000 hits that require access to the database or 50 hits
that require access to the database?

50 - 100 hits that require access

[David W. Fenton]

To**@powellprint.co.uk (Tony S) wrote in
<vt********************************@4ax.com>:

As a filemaker devolper this is a strange place to be
but I have a question.
We have had a web site devolped which is using MS access,
the web designer has advised us that as we are getting near to
5000 hits daily, and wil be be possibly getting maybe 50 orders a
day that Access is likely to fall over under the load, and crash,
so he will need to re-devolp the site with a more robust database.
Your experienced comments please!!

Michael Kaplan used to say that his website, trigeminal.com, which
(at the time, at least) used Jet for the back end, was getting 10s
of thousands of hits each day. I am not certain, but I think it may
have even been approaching 100K per day.

So, yes, proper design can lead to a very robust site.

However, Michael's site is read-only. If you're writing to the
database, you're going to have possible contention if there are
many users simultaneously attempting to write.

There's really no way to answer the question, but I wouldn't choose
Jet for a back end for a website simply because only ASP-based web
hosting companies are likely to support it and I think ASP is the
wrong choice (requiring IIS as it does). I would never host a
website with a company that uses IIS.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[XMVP]

"Tony S" <To**@powellprint.co.uk> wrote in message
news:vt********************************@4ax.com...

As a filemaker devolper this is a strange place to be
but I have a question.
We have had a web site devolped which is using MS access,
the web designer has advised us that as we are getting near to
5000 hits daily, and wil be be possibly getting maybe 50 orders a day
that Access is likely to fall over under the load, and crash, so he
will need to re-devolp the site with a more robust database.
Your experienced comments please!!

Many thank in advance

Tony

Listen to Linson or Fenton and you will be extremely sorry. Neither one of
them knows anything about Web sites that use Access. They have been
repeating the same old falsehoods for many years. Microsoft, or any Web
host provider, will set you straight: Do not use Access Jet!