|
 |
asp_databases thread: How much can Access take?
Message #1 by "Marcus Hamilton" <marcus@p...> on Tue, 24 Jul 2001 21:33:31
|
|
Hi,
Does anybody have any idea as to how much strain Access can take, and how
any stress would manifest itself?
I have an ASP site which uses serveral Access tables exceeding 20MB, and
the site usually has no more than 100 concurrent users at any one time. I
deal with concurrency conflicts by catching the error so that the user
does not see any scripting errors.
Sometimes however, the ASP just fails. It fails for all the ASP
applications on the server, however, non-ASP pages work fine. The failure
manifest itself by taking forever when a page is requested. The page never
gets displayed.
Resetting the machine resolves the problem.
The platform is Windows 2000 IIS5.
Any ideas would be most welcome.
Regards
Marcus
Message #2 by Jeff Scott <jscott17171@y...> on Tue, 24 Jul 2001 13:43:58 -0700 (PDT)
|
|
I may be wrong, but I would recommend sql server 7 for
this type of activity.
I believe access can only handle up to 25 users at a
time and then there will be problems, crashing, etc.
jeff
--- Marcus Hamilton <marcus@p...> wrote:
> Hi,
>
> Does anybody have any idea as to how much strain
> Access can take, and how
> any stress would manifest itself?
>
> I have an ASP site which uses serveral Access tables
> exceeding 20MB, and
> the site usually has no more than 100 concurrent
> users at any one time. I
> deal with concurrency conflicts by catching the
> error so that the user
> does not see any scripting errors.
>
> Sometimes however, the ASP just fails. It fails for
> all the ASP
> applications on the server, however, non-ASP pages
> work fine. The failure
> manifest itself by taking forever when a page is
> requested. The page never
> gets displayed.
>
> Resetting the machine resolves the problem.
>
> The platform is Windows 2000 IIS5.
>
> Any ideas would be most welcome.
>
> Regards
> Marcus
>
Message #3 by "Tomm Matthis" <matthis@b...> on Tue, 24 Jul 2001 16:45:15 -0400
|
|
100 concurrent users!!!
Aiyieeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee!!!
-- Tomm
> -----Original Message-----
> From: Marcus Hamilton [mailto:marcus@p...]
> Sent: Tuesday, July 24, 2001 9:34 PM
> To: ASP Databases
> Subject: [asp_databases] How much can Access take?
>
>
> Hi,
>
> Does anybody have any idea as to how much strain Access can take, and
how
> any stress would manifest itself?
>
> I have an ASP site which uses serveral Access tables exceeding 20MB,
and
> the site usually has no more than 100 concurrent users at any one
time. I
> deal with concurrency conflicts by catching the error so that the user
> does not see any scripting errors.
>
> Sometimes however, the ASP just fails. It fails for all the ASP
> applications on the server, however, non-ASP pages work fine. The
failure
> manifest itself by taking forever when a page is requested. The
> page never
> gets displayed.
>
> Resetting the machine resolves the problem.
>
> The platform is Windows 2000 IIS5.
>
> Any ideas would be most welcome.
>
> Regards
> Marcus
>
Message #4 by "Grant I" <giswim1@a...> on Tue, 24 Jul 2001 22:08:23
|
|
Marcus -
Check out http://msdn.microsoft.com/library/default.asp?url=/library/en-
us/dnacc2k/html/acmsdeop.asp
Here, you will see that Microsoft says that Access Jet Engine can handle a
maximum of 255 users. However, I have read people's complaints that, when
load testing, as few as 10 concurrent connections generate an error.
Basically, the number of people able to access your site at the same time
depends on your site. You'll have to do load testing for yourself to
determine what that number is. While I haven't used it myself, I always
see people recommend Microsoft's load-testing utility. You can read about
and download it at http://webtool.rte.microsoft.com/
One thing you may want to make sure of is that you are closing ALL
connections to the database and that you're doing so as soon as you are
through with them. If you're leaving the connections open, you will run a
much higher risk of concurrency errors. For instance, if you are
retrieving records into a recordset and outputting to the screen, be sure
that as soon as you are done with output, you close both the recordset and
connection to the db and set the objects to nothing. I know this may seem
like something you would say to a beginner, but it doesn't hurt to pound
it home :)
objRS.Close
objConn.Close
set objRS = nothing
set objConn = nothing
Hope this helps
Grant
> Hi,
>
> Does anybody have any idea as to how much strain Access can take, and
how
> any stress would manifest itself?
>
> I have an ASP site which uses serveral Access tables exceeding 20MB, and
> the site usually has no more than 100 concurrent users at any one time.
I
> deal with concurrency conflicts by catching the error so that the user
> does not see any scripting errors.
>
> Sometimes however, the ASP just fails. It fails for all the ASP
> applications on the server, however, non-ASP pages work fine. The
failure
> manifest itself by taking forever when a page is requested. The page
never
> gets displayed.
>
> Resetting the machine resolves the problem.
>
> The platform is Windows 2000 IIS5.
>
> Any ideas would be most welcome.
>
> Regards
> Marcus
Message #5 by "Grant I" <giswim1@a...> on Tue, 24 Jul 2001 22:15:27
|
|
Marcus -
I forgot to post this link as well. It is a great discussion about your
issue on 15seconds. You really should check it out before you consider
changing databases.
http://www.15seconds.com/issue/010514.htm
HTH
Grant
> 100 concurrent users!!!
>
> Aiyieeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee!!!
>
> -- Tomm
>
> > -----Original Message-----
> > From: Marcus Hamilton [mailto:marcus@p...]
> > Sent: Tuesday, July 24, 2001 9:34 PM
> > To: ASP Databases
> > Subject: [asp_databases] How much can Access take?
> >
> >
> > Hi,
> >
> > Does anybody have any idea as to how much strain Access can take, and
> how
> > any stress would manifest itself?
> >
> > I have an ASP site which uses serveral Access tables exceeding 20MB,
> and
> > the site usually has no more than 100 concurrent users at any one
> time. I
> > deal with concurrency conflicts by catching the error so that the user
>
> > does not see any scripting errors.
> >
> > Sometimes however, the ASP just fails. It fails for all the ASP
> > applications on the server, however, non-ASP pages work fine. The
> failure
> > manifest itself by taking forever when a page is requested. The
> > page never
> > gets displayed.
> >
> > Resetting the machine resolves the problem.
> >
> > The platform is Windows 2000 IIS5.
> >
> > Any ideas would be most welcome.
> >
> > Regards
> > Marcus
> >
Message #6 by "Daniel Walker" <danielw@w...> on Wed, 25 Jul 2001 00:37:43
|
|
Check out my conversation of the last few hours with Kien on the
asp_database_setup list:
http://p2p.wrox.com/view.asp?list=asp_database_setup&id=86277
mySQL is an alternative worth considering, if you are only doing
read-only, read-and-append, or read-and-lightly-modify operations on your
datastore. Case in point: http://p2p.wrox.com/ - the whole of this site's
front end runs off a mySQL databse, and every page makes at least some call
to the DBM... and yet it can carry four or five times the traffic Tomm is
baulking at. (p2p has a ten minute session time-out, so the figures it
delivers on the front page approach reality, I suspect: earlier today it
was well into the 150's-type mark and it's been at 450-500 simluateous
before now.)
Daniel Walker
Wrox Press
> 100 concurrent users!!!
>
> Aiyieeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee!!!
>
> -- Tomm
>
> > -----Original Message-----
> > From: Marcus Hamilton [mailto:marcus@p...]
> > Sent: Tuesday, July 24, 2001 9:34 PM
> > To: ASP Databases
> > Subject: [asp_databases] How much can Access take?
> >
> >
> > Hi,
> >
> > Does anybody have any idea as to how much strain Access can take, and
> how
> > any stress would manifest itself?
> >
> > I have an ASP site which uses serveral Access tables exceeding 20MB,
> and
> > the site usually has no more than 100 concurrent users at any one
> time. I
> > deal with concurrency conflicts by catching the error so that the
user
>
> > does not see any scripting errors.
> >
> > Sometimes however, the ASP just fails. It fails for all the ASP
> > applications on the server, however, non-ASP pages work fine. The
> failure
> > manifest itself by taking forever when a page is requested. The
> > page never
> > gets displayed.
> >
> > Resetting the machine resolves the problem.
> >
> > The platform is Windows 2000 IIS5.
> >
> > Any ideas would be most welcome.
> >
> > Regards
> > Marcus
> >
Message #7 by "Al Augustinas" <aaugustinas@h...> on Tue, 24 Jul 2001 20:07:35 -0500
|
|
Marcus
Time to move to SQL Server or some other database server
Al
-----Original Message-----
From: Marcus Hamilton [mailto:marcus@p...]
Sent: Tuesday, July 24, 2001 9:34 PM
To: ASP Databases
Subject: [asp_databases] How much can Access take?
Hi,
Does anybody have any idea as to how much strain Access can take, and how
any stress would manifest itself?
I have an ASP site which uses serveral Access tables exceeding 20MB, and
the site usually has no more than 100 concurrent users at any one time. I
deal with concurrency conflicts by catching the error so that the user
does not see any scripting errors.
Sometimes however, the ASP just fails. It fails for all the ASP
applications on the server, however, non-ASP pages work fine. The failure
manifest itself by taking forever when a page is requested. The page never
gets displayed.
Resetting the machine resolves the problem.
The platform is Windows 2000 IIS5.
Any ideas would be most welcome.
Regards
Marcus
Message #8 by Steve Carter <Steve.Carter@t...> on Wed, 25 Jul 2001 10:32:44 +0100
|
|
I've often heard tell that access can handle 100 concurrent users.
Unfortunately a web session typically uses up 2 - 4 database 'users' so
the
number is nearer to 30.
> -----Original Message-----
> From: Tomm Matthis [mailto:matthis@b...]
> Sent: 24 July 2001 21:45
> To: ASP Databases
> Subject: [asp_databases] RE: How much can Access take?
>
>
> 100 concurrent users!!!
>
> Aiyieeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee!!!
>
> -- Tomm
>
> > -----Original Message-----
> > From: Marcus Hamilton [mailto:marcus@p...]
> > Sent: Tuesday, July 24, 2001 9:34 PM
> > To: ASP Databases
> > Subject: [asp_databases] How much can Access take?
> >
> >
> > Hi,
> >
> > Does anybody have any idea as to how much strain Access can
> take, and how
> > any stress would manifest itself?
> >
> > I have an ASP site which uses serveral Access tables
> exceeding 20MB, and
> > the site usually has no more than 100 concurrent users at
> any one time. I
> > deal with concurrency conflicts by catching the error so
> that the user
> > does not see any scripting errors.
> >
> > Sometimes however, the ASP just fails. It fails for all the ASP
> > applications on the server, however, non-ASP pages work
> fine. The failure
> > manifest itself by taking forever when a page is requested. The
> > page never
> > gets displayed.
> >
> > Resetting the machine resolves the problem.
> >
> > The platform is Windows 2000 IIS5.
> >
> > Any ideas would be most welcome.
> >
> > Regards
> > Marcus
> >
>
Message #9 by Steve Carter <Steve.Carter@t...> on Wed, 25 Jul 2001 10:45:45 +0100
|
|
Excellent page (except the bit about getting arsey with management,
which I
don't think will help anyone!)
Has anyone any pointers to information on how to create a
multiple-recordset
query?
> -----Original Message-----
> From: Grant I [mailto:giswim1@a...]
> Sent: 24 July 2001 23:15
> To: ASP Databases
> Subject: [asp_databases] RE: How much can Access take?
>
>
> Marcus -
>
> I forgot to post this link as well. It is a great discussion
> about your
> issue on 15seconds. You really should check it out before
> you consider
> changing databases.
>
> http://www.15seconds.com/issue/010514.htm
>
> HTH
> Grant
>
> > 100 concurrent users!!!
> >
> > Aiyieeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee!!!
> >
> > -- Tomm
> >
> > > -----Original Message-----
> > > From: Marcus Hamilton [mailto:marcus@p...]
> > > Sent: Tuesday, July 24, 2001 9:34 PM
> > > To: ASP Databases
> > > Subject: [asp_databases] How much can Access take?
> > >=3D20
> > >=3D20
> > > Hi,
> > >=3D20
> > > Does anybody have any idea as to how much strain Access
> can take, and =3D
> > how=3D20
> > > any stress would manifest itself?
> > >=3D20
> > > I have an ASP site which uses serveral Access tables
> exceeding 20MB, =3D
> > and=3D20
> > > the site usually has no more than 100 concurrent users at
> any one =3D
> > time. I=3D20
> > > deal with concurrency conflicts by catching the error so
> that the user
> =3D
> >
> > > does not see any scripting errors.
> > >=3D20
> > > Sometimes however, the ASP just fails. It fails for all the
ASP=3D20
> > > applications on the server, however, non-ASP pages work
> fine. The =3D
> > failure=3D20
> > > manifest itself by taking forever when a page is requested.
The=3D20
> > > page never=3D20
> > > gets displayed.
> > >=3D20
> > > Resetting the machine resolves the problem.
> > >=3D20
> > > The platform is Windows 2000 IIS5.
> > >=3D20
> > > Any ideas would be most welcome.
> > >=3D20
> > > Regards
> > > Marcus
> > >
>
Message #10 by "Tomm Matthis" <matthis@b...> on Wed, 25 Jul 2001 06:41:36 -0400
|
|
At this time mySQL doesn't support sprocs does it? Are there plans to add
that functionality in the near future?
At work, we use MS Sql, but I am working with a non-profit organization that
would be very interested in mySQL 'cause of the $$ factor.... but I'd really
miss not having sprocs...
-- Tomm
> -----Original Message-----
> From: Daniel Walker [mailto:danielw@w...]
> Sent: Wednesday, July 25, 2001 12:38 AM
> To: ASP Databases
> Subject: [asp_databases] RE: How much can Access take?
>
>
> Check out my conversation of the last few hours with Kien on the
> asp_database_setup list:
> http://p2p.wrox.com/view.asp?list=asp_database_setup&id=86277
>
> mySQL is an alternative worth considering, if you are only doing
> read-only, read-and-append, or read-and-lightly-modify operations on your
> datastore. Case in point: http://p2p.wrox.com/ - the whole of this site's
> front end runs off a mySQL databse, and every page makes at least
> some call
> to the DBM... and yet it can carry four or five times the traffic Tomm is
> baulking at. (p2p has a ten minute session time-out, so the figures it
> delivers on the front page approach reality, I suspect: earlier today it
> was well into the 150's-type mark and it's been at 450-500 simluateous
> before now.)
>
> Daniel Walker
> Wrox Press
>
> > 100 concurrent users!!!
> >
> > Aiyieeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee!!!
> >
> > -- Tomm
> >
> > > -----Original Message-----
> > > From: Marcus Hamilton [mailto:marcus@p...]
> > > Sent: Tuesday, July 24, 2001 9:34 PM
> > > To: ASP Databases
> > > Subject: [asp_databases] How much can Access take?
> > >
> > >
> > > Hi,
> > >
> > > Does anybody have any idea as to how much strain Access can take, and
>
> > how
> > > any stress would manifest itself?
> > >
> > > I have an ASP site which uses serveral Access tables exceeding 20MB,
> > and
> > > the site usually has no more than 100 concurrent users at any one
> > time. I
> > > deal with concurrency conflicts by catching the error so that the
> user
> >
> > > does not see any scripting errors.
> > >
> > > Sometimes however, the ASP just fails. It fails for all the ASP
> > > applications on the server, however, non-ASP pages work fine. The
> > failure
> > > manifest itself by taking forever when a page is requested. The
> > > page never
> > > gets displayed.
> > >
> > > Resetting the machine resolves the problem.
> > >
> > > The platform is Windows 2000 IIS5.
> > >
> > > Any ideas would be most welcome.
> > >
> > > Regards
> > > Marcus
> > >
Message #11 by kalyan_ramji@h... on Wed, 25 Jul 2001 13:57:47
|
|
100 Users!! Forget 100, my school used an Access database to set up a
webboard for students and we had a problem with 25 users logging on at the
same time. The webboard admin. had to change the database to SQL server.
But even then, it was working fine, but when the number of users increased
to say like 80 it slowed down too.. It was working but was slower than
earlier. Can anyone tell me which is the best database that would handle
huuugge data and still go lightining fast?
> At this time mySQL doesn't support sprocs does it? Are there plans to add
> that functionality in the near future?
>
> At work, we use MS Sql, but I am working with a non-profit organization
that
> would be very interested in mySQL 'cause of the $$ factor.... but I'd
really
> miss not having sprocs...
>
> -- Tomm
>
> > -----Original Message-----
> > From: Daniel Walker [mailto:danielw@w...]
> > Sent: Wednesday, July 25, 2001 12:38 AM
> > To: ASP Databases
> > Subject: [asp_databases] RE: How much can Access take?
> >
> >
> > Check out my conversation of the last few hours with Kien on the
> > asp_database_setup list:
> > http://p2p.wrox.com/view.asp?list=asp_database_setup&id=86277
> >
> > mySQL is an alternative worth considering, if you are only doing
> > read-only, read-and-append, or read-and-lightly-modify operations on
your
> > datastore. Case in point: http://p2p.wrox.com/ - the whole of this
site's
> > front end runs off a mySQL databse, and every page makes at least
> > some call
> > to the DBM... and yet it can carry four or five times the traffic Tomm
is
> > baulking at. (p2p has a ten minute session time-out, so the figures it
> > delivers on the front page approach reality, I suspect: earlier today
it
> > was well into the 150's-type mark and it's been at 450-500 simluateous
> > before now.)
> >
> > Daniel Walker
> > Wrox Press
> >
> > > 100 concurrent users!!!
> > >
> > > Aiyieeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee!!!
> > >
> > > -- Tomm
> > >
> > > > -----Original Message-----
> > > > From: Marcus Hamilton [mailto:marcus@p...]
> > > > Sent: Tuesday, July 24, 2001 9:34 PM
> > > > To: ASP Databases
> > > > Subject: [asp_databases] How much can Access take?
> > > >
> > > >
> > > > Hi,
> > > >
> > > > Does anybody have any idea as to how much strain Access can take,
and
> >
> > > how
> > > > any stress would manifest itself?
> > > >
> > > > I have an ASP site which uses serveral Access tables exceeding
20MB,
> > > and
> > > > the site usually has no more than 100 concurrent users at any one
> > > time. I
> > > > deal with concurrency conflicts by catching the error so that the
> > user
> > >
> > > > does not see any scripting errors.
> > > >
> > > > Sometimes however, the ASP just fails. It fails for all the ASP
> > > > applications on the server, however, non-ASP pages work fine. The
> > > failure
> > > > manifest itself by taking forever when a page is requested. The
> > > > page never
> > > > gets displayed.
> > > >
> > > > Resetting the machine resolves the problem.
> > > >
> > > > The platform is Windows 2000 IIS5.
> > > >
> > > > Any ideas would be most welcome.
> > > >
> > > > Regards
> > > > Marcus
> > > >
Message #12 by "Craig Flannigan" <ckf@k...> on Wed, 25 Jul 2001 14:12:38 +0100
|
|
SQL Server is only useful when you start using a lot of users (80 isn't
considered "a lot" for SQL Server) and start scaling up a system.
You can actually experience slower results with SQL Server over Access as we
have found out. www.sqlteam.com covered this a while back, but I cannot
remember exactly what the figures are, sorry.
-----Original Message-----
From: kalyan_ramji@h... [mailto:kalyan_ramji@h...]
Sent: Wednesday 25 July 2001 13:58
To: ASP Databases
Subject: [asp_databases] RE: How much can Access take?
100 Users!! Forget 100, my school used an Access database to set up a
webboard for students and we had a problem with 25 users logging on at the
same time. The webboard admin. had to change the database to SQL server.
But even then, it was working fine, but when the number of users increased
to say like 80 it slowed down too.. It was working but was slower than
earlier. Can anyone tell me which is the best database that would handle
huuugge data and still go lightining fast?
> At this time mySQL doesn't support sprocs does it? Are there plans to add
> that functionality in the near future?
>
> At work, we use MS Sql, but I am working with a non-profit organization
that
> would be very interested in mySQL 'cause of the $$ factor.... but I'd
really
> miss not having sprocs...
>
> -- Tomm
>
> > -----Original Message-----
> > From: Daniel Walker [mailto:danielw@w...]
> > Sent: Wednesday, July 25, 2001 12:38 AM
> > To: ASP Databases
> > Subject: [asp_databases] RE: How much can Access take?
> >
> >
> > Check out my conversation of the last few hours with Kien on the
> > asp_database_setup list:
> > http://p2p.wrox.com/view.asp?list=asp_database_setup&id=86277
> >
> > mySQL is an alternative worth considering, if you are only doing
> > read-only, read-and-append, or read-and-lightly-modify operations on
your
> > datastore. Case in point: http://p2p.wrox.com/ - the whole of this
site's
> > front end runs off a mySQL databse, and every page makes at least
> > some call
> > to the DBM... and yet it can carry four or five times the traffic Tomm
is
> > baulking at. (p2p has a ten minute session time-out, so the figures it
> > delivers on the front page approach reality, I suspect: earlier today
it
> > was well into the 150's-type mark and it's been at 450-500 simluateous
> > before now.)
> >
> > Daniel Walker
> > Wrox Press
> >
> > > 100 concurrent users!!!
> > >
> > > Aiyieeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee!!!
> > >
> > > -- Tomm
> > >
> > > > -----Original Message-----
> > > > From: Marcus Hamilton [mailto:marcus@p...]
> > > > Sent: Tuesday, July 24, 2001 9:34 PM
> > > > To: ASP Databases
> > > > Subject: [asp_databases] How much can Access take?
> > > >
> > > >
> > > > Hi,
> > > >
> > > > Does anybody have any idea as to how much strain Access can take,
and
> >
> > > how
> > > > any stress would manifest itself?
> > > >
> > > > I have an ASP site which uses serveral Access tables exceeding
20MB,
> > > and
> > > > the site usually has no more than 100 concurrent users at any one
> > > time. I
> > > > deal with concurrency conflicts by catching the error so that the
> > user
> > >
> > > > does not see any scripting errors.
> > > >
> > > > Sometimes however, the ASP just fails. It fails for all the ASP
> > > > applications on the server, however, non-ASP pages work fine. The
> > > failure
> > > > manifest itself by taking forever when a page is requested. The
> > > > page never
> > > > gets displayed.
> > > >
> > > > Resetting the machine resolves the problem.
> > > >
> > > > The platform is Windows 2000 IIS5.
> > > >
> > > > Any ideas would be most welcome.
> > > >
> > > > Regards
> > > > Marcus
> > > >
Message #13 by "Eoghan O'Byrne" <Eoghan.O'Byrne@W...> on Wed, 25 Jul 2001 14:13:46 +0100
|
|
Hey Kalyan,
If you found performance to decrease with 80 users then the code,
database or both need tuning.
But if you still want to know of an extremely powerful database then
Oracle is the answer.
The current version is 9i.
For a school even if the school has 2000 students SQL Server will do
fine especially if its only for a webboard.
Regards,
Eoghan
-----Original Message-----
From: kalyan_ramji@h... [mailto:kalyan_ramji@h...]
Sent: Wednesday, July 25, 2001 2:58 PM
To: ASP Databases
Subject: [asp_databases] RE: How much can Access take?
100 Users!! Forget 100, my school used an Access database to set up a
webboard for students and we had a problem with 25 users logging on at
the
same time. The webboard admin. had to change the database to SQL server.
But even then, it was working fine, but when the number of users
increased
to say like 80 it slowed down too.. It was working but was slower than
earlier. Can anyone tell me which is the best database that would handle
huuugge data and still go lightining fast?
> At this time mySQL doesn't support sprocs does it? Are there plans to
add
> that functionality in the near future?
>
> At work, we use MS Sql, but I am working with a non-profit
organization
that
> would be very interested in mySQL 'cause of the $$ factor.... but I'd
really
> miss not having sprocs...
>
> -- Tomm
>
> > -----Original Message-----
> > From: Daniel Walker [mailto:danielw@w...]
> > Sent: Wednesday, July 25, 2001 12:38 AM
> > To: ASP Databases
> > Subject: [asp_databases] RE: How much can Access take?
> >
> >
> > Check out my conversation of the last few hours with Kien on the
> > asp_database_setup list:
> > http://p2p.wrox.com/view.asp?list=3Dasp_database_setup&id=3D86277
> >
> > mySQL is an alternative worth considering, if you are only doing
> > read-only, read-and-append, or read-and-lightly-modify operations on
your
> > datastore. Case in point: http://p2p.wrox.com/ - the whole of this
site's
> > front end runs off a mySQL databse, and every page makes at least
> > some call
> > to the DBM... and yet it can carry four or five times the traffic
Tomm
is
> > baulking at. (p2p has a ten minute session time-out, so the figures
it
> > delivers on the front page approach reality, I suspect: earlier
today
it
> > was well into the 150's-type mark and it's been at 450-500
simluateous
> > before now.)
> >
> > Daniel Walker
> > Wrox Press
> >
> > > 100 concurrent users!!!
> > >
> > > Aiyieeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee!!!
> > >
> > > -- Tomm
> > >
> > > > -----Original Message-----
> > > > From: Marcus Hamilton [mailto:marcus@p...]
> > > > Sent: Tuesday, July 24, 2001 9:34 PM
> > > > To: ASP Databases
> > > > Subject: [asp_databases] How much can Access take?
> > > >=3D20
> > > >=3D20
> > > > Hi,
> > > >=3D20
> > > > Does anybody have any idea as to how much strain Access can
take,
and
> > =3D
> > > how=3D20
> > > > any stress would manifest itself?
> > > >=3D20
> > > > I have an ASP site which uses serveral Access tables exceeding
20MB, =3D
> > > and=3D20
> > > > the site usually has no more than 100 concurrent users at any
one =3D
> > > time. I=3D20
> > > > deal with concurrency conflicts by catching the error so that
the
> > user =3D
> > >
> > > > does not see any scripting errors.
> > > >=3D20
> > > > Sometimes however, the ASP just fails. It fails for all the
ASP=3D20
> > > > applications on the server, however, non-ASP pages work fine.
The =3D
> > > failure=3D20
> > > > manifest itself by taking forever when a page is requested.
The=3D20
> > > > page never=3D20
> > > > gets displayed.
> > > >=3D20
> > > > Resetting the machine resolves the problem.
> > > >=3D20
> > > > The platform is Windows 2000 IIS5.
> > > >=3D20
> > > > Any ideas would be most welcome.
> > > >=3D20
> > > > Regards
> > > > Marcus
> > > >
Message #14 by kalyan_ramji@h... on Wed, 25 Jul 2001 14:45:40
|
|
Could it be a problem with the network. Just curious.. Sorry if I am
dragging this too long..
> Hey Kalyan,
>
> If you found performance to decrease with 80 users then the code,
> database or both need tuning.
>
> But if you still want to know of an extremely powerful database then
> Oracle is the answer.
> The current version is 9i.
>
> For a school even if the school has 2000 students SQL Server will do
> fine especially if its only for a webboard.
>
> Regards,
>
> Eoghan
>
> -----Original Message-----
> From: kalyan_ramji@h... [mailto:kalyan_ramji@h...]
> Sent: Wednesday, July 25, 2001 2:58 PM
> To: ASP Databases
> Subject: [asp_databases] RE: How much can Access take?
>
>
> 100 Users!! Forget 100, my school used an Access database to set up a
> webboard for students and we had a problem with 25 users logging on at
> the
> same time. The webboard admin. had to change the database to SQL server.
>
> But even then, it was working fine, but when the number of users
> increased
> to say like 80 it slowed down too.. It was working but was slower than
> earlier. Can anyone tell me which is the best database that would handle
>
> huuugge data and still go lightining fast?
>
> > At this time mySQL doesn't support sprocs does it? Are there plans to
> add
> > that functionality in the near future?
> >
> > At work, we use MS Sql, but I am working with a non-profit
> organization
> that
> > would be very interested in mySQL 'cause of the $$ factor.... but
I'd
> really
> > miss not having sprocs...
> >
> > -- Tomm
> >
> > > -----Original Message-----
> > > From: Daniel Walker [mailto:danielw@w...]
> > > Sent: Wednesday, July 25, 2001 12:38 AM
> > > To: ASP Databases
> > > Subject: [asp_databases] RE: How much can Access take?
> > >
> > >
> > > Check out my conversation of the last few hours with Kien on the
> > > asp_database_setup list:
> > > http://p2p.wrox.com/view.asp?list=3Dasp_database_setup&id=3D86277
> > >
> > > mySQL is an alternative worth considering, if you are only doing
> > > read-only, read-and-append, or read-and-lightly-modify operations on
>
> your
> > > datastore. Case in point: http://p2p.wrox.com/ - the whole of this
> site's
> > > front end runs off a mySQL databse, and every page makes at least
> > > some call
> > > to the DBM... and yet it can carry four or five times the traffic
> Tomm
> is
> > > baulking at. (p2p has a ten minute session time-out, so the figures
> it
> > > delivers on the front page approach reality, I suspect: earlier
> today
> it
> > > was well into the 150's-type mark and it's been at 450-500
> simluateous
> > > before now.)
> > >
> > > Daniel Walker
> > > Wrox Press
> > >
> > > > 100 concurrent users!!!
> > > >
> > > > Aiyieeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee!!!
> > > >
> > > > -- Tomm
> > > >
> > > > > -----Original Message-----
> > > > > From: Marcus Hamilton [mailto:marcus@p...]
> > > > > Sent: Tuesday, July 24, 2001 9:34 PM
> > > > > To: ASP Databases
> > > > > Subject: [asp_databases] How much can Access take?
> > > > >=3D20
> > > > >=3D20
> > > > > Hi,
> > > > >=3D20
> > > > > Does anybody have any idea as to how much strain Access can
> take,
> and
> > > =3D
> > > > how=3D20
> > > > > any stress would manifest itself?
> > > > >=3D20
> > > > > I have an ASP site which uses serveral Access tables exceeding
> 20MB, =3D
> > > > and=3D20
> > > > > the site usually has no more than 100 concurrent users at any
> one =3D
> > > > time. I=3D20
> > > > > deal with concurrency conflicts by catching the error so that
> the
> > > user =3D
> > > >
> > > > > does not see any scripting errors.
> > > > >=3D20
> > > > > Sometimes however, the ASP just fails. It fails for all the
> ASP=3D20
> > > > > applications on the server, however, non-ASP pages work fine.
> The =3D
> > > > failure=3D20
> > > > > manifest itself by taking forever when a page is requested.
> The=3D20
> > > > > page never=3D20
> > > > > gets displayed.
> > > > >=3D20
> > > > > Resetting the machine resolves the problem.
> > > > >=3D20
> > > > > The platform is Windows 2000 IIS5.
> > > > >=3D20
> > > > > Any ideas would be most welcome.
> > > > >=3D20
> > > > > Regards
> > > > > Marcus
> > > > >
Message #15 by "Eoghan O'Byrne" <Eoghan.O'Byrne@W...> on Wed, 25 Jul 2001 14:52:04 +0100
|
|
Really it could be a number of things,
bad code (unclosed recordsets, cartesian products etc.), slow connection
speed, if the server is low spec, if there are multiple databases on the
server all being hit with requests from a large user base or if it has
only been happening recently and ur getting denial of service it could
have been the code red worm.
It could also be that the message threads are big so the code takes a
while to return.
I wouldnt say its anything serious, probbaly just need some slight
tuning.
Regards,
Eoghan
-----Original Message-----
From: kalyan_ramji@h... [mailto:kalyan_ramji@h...]
Sent: Wednesday, July 25, 2001 3:46 PM
To: ASP Databases
Subject: [asp_databases] RE: How much can Access take?
Could it be a problem with the network. Just curious.. Sorry if I am
dragging this too long..
> Hey Kalyan,
>
> If you found performance to decrease with 80 users then the code,
> database or both need tuning.
>
> But if you still want to know of an extremely powerful database then
> Oracle is the answer.
> The current version is 9i.
>
> For a school even if the school has 2000 students SQL Server will do
> fine especially if its only for a webboard.
>
> Regards,
>
> Eoghan
>
> -----Original Message-----
> From: kalyan_ramji@h... [mailto:kalyan_ramji@h...]
> Sent: Wednesday, July 25, 2001 2:58 PM
> To: ASP Databases
> Subject: [asp_databases] RE: How much can Access take?
>
>
> 100 Users!! Forget 100, my school used an Access database to set up
a=3D20
> webboard for students and we had a problem with 25 users logging on at
> the=3D20
> same time. The webboard admin. had to change the database to SQL
server.
>
> But even then, it was working fine, but when the number of users
> increased=3D20
> to say like 80 it slowed down too.. It was working but was slower
than=3D20
> earlier. Can anyone tell me which is the best database that would
handle
>
> huuugge data and still go lightining fast?=3D20
>
> > At this time mySQL doesn't support sprocs does it? Are there plans
to
> add
> > that functionality in the near future?
> >=3D20
> > At work, we use MS Sql, but I am working with a non-profit
> organization=3D20
> that
> > would be very interested in mySQL 'cause of the $$ factor.... but
I'd=3D20
> really
> > miss not having sprocs...
> >=3D20
> > -- Tomm
> >=3D20
> > > -----Original Message-----
> > > From: Daniel Walker [mailto:danielw@w...]
> > > Sent: Wednesday, July 25, 2001 12:38 AM
> > > To: ASP Databases
> > > Subject: [asp_databases] RE: How much can Access take?
> > >
> > >
> > > Check out my conversation of the last few hours with Kien on the
> > > asp_database_setup list:
> > >
http://p2p.wrox.com/view.asp?list=3D3Dasp_database_setup&id=3D3D86277
> > >
> > > mySQL is an alternative worth considering, if you are only doing
> > > read-only, read-and-append, or read-and-lightly-modify operations
on
>
> your
> > > datastore. Case in point: http://p2p.wrox.com/ - the whole of
this=3D20
> site's
> > > front end runs off a mySQL databse, and every page makes at least
> > > some call
> > > to the DBM... and yet it can carry four or five times the traffic
> Tomm=3D20
> is
> > > baulking at. (p2p has a ten minute session time-out, so the
figures
> it
> > > delivers on the front page approach reality, I suspect: earlier
> today=3D20
> it
> > > was well into the 150's-type mark and it's been at 450-500
> simluateous
> > > before now.)
> > >
> > > Daniel Walker
> > > Wrox Press
> > >
> > > > 100 concurrent users!!!
> > > >
> > > > Aiyieeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee!!!
> > > >
> > > > -- Tomm
> > > >
> > > > > -----Original Message-----
> > > > > From: Marcus Hamilton [mailto:marcus@p...]
> > > > > Sent: Tuesday, July 24, 2001 9:34 PM
> > > > > To: ASP Databases
> > > > > Subject: [asp_databases] How much can Access take?
> > > > >=3D3D20
> > > > >=3D3D20
> > > > > Hi,
> > > > >=3D3D20
> > > > > Does anybody have any idea as to how much strain Access can
> take,=3D20
> and
> > > =3D3D
> > > > how=3D3D20
> > > > > any stress would manifest itself?
> > > > >=3D3D20
> > > > > I have an ASP site which uses serveral Access tables
exceeding=3D20
> 20MB, =3D3D
> > > > and=3D3D20
> > > > > the site usually has no more than 100 concurrent users at any
> one =3D3D
> > > > time. I=3D3D20
> > > > > deal with concurrency conflicts by catching the error so that
> the
> > > user =3D3D
> > > >
> > > > > does not see any scripting errors.
> > > > >=3D3D20
> > > > > Sometimes however, the ASP just fails. It fails for all the
> ASP=3D3D20
> > > > > applications on the server, however, non-ASP pages work fine.
> The =3D3D
> > > > failure=3D3D20
> > > > > manifest itself by taking forever when a page is requested.
> The=3D3D20
> > > > > page never=3D3D20
> > > > > gets displayed.
> > > > >=3D3D20
> > > > > Resetting the machine resolves the problem.
> > > > >=3D3D20
> > > > > The platform is Windows 2000 IIS5.
> > > > >=3D3D20
> > > > > Any ideas would be most welcome.
> > > > >=3D3D20
> > > > > Regards
> > > > > Marcus
> > > > >
Message #16 by kalyan_ramji@h... on Wed, 25 Jul 2001 15:21:55
|
|
Thanks Eoghan.. Any clues on my connectivity issue.. Microsoft also says
that I need to reinstall MADC and I am using IIS 4.0.. But I am not sure
as to which version of MADC I need to reinstall cos in the link given by
Microsoft there are lots. Thanks for your help..
Message #17 by "Daniel Walker" <danielw@w...> on Wed, 25 Jul 2001 15:38:27
|
|
All the provisos about mySQL I made to Kien on the other lsit still stand. No sprocs, no
triggers, no transaction management, no a lot of things... but if your database work only
involves read-only or read-and-append type work, then mySQL can be a lot faster than
other alternatives. I would never want to start running an e-commerce site off it, but many
sites can and could run on mySQL. You can get a lot of harware for the cost of some
software licenses: which will quicken your website most - replacing a p100 with a Dell
Poweredge, or installing SQL Server on the P100?
Maybe you should consider using Postgre SQL? I've never used it, but Adam Lang on
the Pro PHP list described it as "Open source Oracle". Adam isn't given to saying such
things idly. I've heard of memory leakage problems with Postgre SQL in the past. These
may have been fixed by now, however. When evaluating open source software, it is
best to get impartial reviews that deal with the very latest distributions because
development and improvement does tend to happen a lot faster in the open source world
than elsewhere: what may have been crap six months ago maybe the very thing you
need, by now. I've certainly seen PHP sites that run on Postgres that work like a dream.
Daniel Walker
Wrox Press
> At this time mySQL doesn't support sprocs does it? Are there plans to add
> that functionality in the near future?
>
> At work, we use MS Sql, but I am working with a non-profit organization that
> would be very interested in mySQL 'cause of the $$ factor.... but I'd really
> miss not having sprocs...
>
> -- Tomm
>
> > -----Original Message-----
> > From: Daniel Walker [mailto:danielw@w...]
> > Sent: Wednesday, July 25, 2001 12:38 AM
> > To: ASP Databases
> > Subject: [asp_databases] RE: How much can Access take?
> >
> >
> > Check out my conversation of the last few hours with Kien on the
> > asp_database_setup list:
> > http://p2p.wrox.com/view.asp?list=asp_database_setup&id=86277
> >
> > mySQL is an alternative worth considering, if you are only doing
> > read-only, read-and-append, or read-and-lightly-modify operations on your
> > datastore. Case in point: http://p2p.wrox.com/ - the whole of this site's
> > front end runs off a mySQL databse, and every page makes at least
> > some call
> > to the DBM... and yet it can carry four or five times the traffic Tomm is
> > baulking at. (p2p has a ten minute session time-out, so the figures it
> > delivers on the front page approach reality, I suspect: earlier today it
> > was well into the 150's-type mark and it's been at 450-500 simluateous
> > before now.)
> >
> > Daniel Walker
> > Wrox Press
> >
> > > 100 concurrent users!!!
> > >
> > > Aiyieeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee!!!
> > >
> > > -- Tomm
> > >
> > > > -----Original Message-----
> > > > From: Marcus Hamilton [mailto:marcus@p...]
> > > > Sent: Tuesday, July 24, 2001 9:34 PM
> > > > To: ASP Databases
> > > > Subject: [asp_databases] How much can Access take?
> > > >
> > > >
> > > > Hi,
> > > >
> > > > Does anybody have any idea as to how much strain Access can take, and
> >
> > > how
> > > > any stress would manifest itself?
> > > >
> > > > I have an ASP site which uses serveral Access tables exceeding 20MB,
> > > and
> > > > the site usually has no more than 100 concurrent users at any one
> > > time. I
> > > > deal with concurrency conflicts by catching the error so that the
> > user
> > >
> > > > does not see any scripting errors.
> > > >
> > > > Sometimes however, the ASP just fails. It fails for all the ASP
> > > > applications on the server, however, non-ASP pages work fine. The
> > > failure
> > > > manifest itself by taking forever when a page is requested. The
> > > > page never
> > > > gets displayed.
> > > >
> > > > Resetting the machine resolves the problem.
> > > >
> > > > The platform is Windows 2000 IIS5.
> > > >
> > > > Any ideas would be most welcome.
> > > >
> > > > Regards
> > > > Marcus
> > > >
Message #18 by Sam Clohesy <sam@e...> on Wed, 25 Jul 2001 15:38:42 +0100
|
|
I think the latest is 2.6.
Go with that
-----Original Message-----
From: kalyan_ramji@h... [mailto:kalyan_ramji@h...]
Sent: 25 July 2001 16:22
To: ASP Databases
Subject: [asp_databases] RE: How much can Access take?
Thanks Eoghan.. Any clues on my connectivity issue.. Microsoft also says
that I need to reinstall MADC and I am using IIS 4.0.. But I am not sure
as to which version of MADC I need to reinstall cos in the link given by
Microsoft there are lots. Thanks for your help..
Message #19 by "Craig Flannigan" <ckf@k...> on Wed, 25 Jul 2001 15:41:53 +0100
|
|
The latest is 2.7, although as Sam suggested, go with 2.6 RTM as 2.7 is in
Beta, and caused several of our systems to stop working correctly.
You might also want to download Jet 4 SP3 from the same site while you're
there.
-----Original Message-----
From: Sam Clohesy [mailto:sam@e...]
Sent: Wednesday 25 July 2001 15:39
To: ASP Databases
Subject: [asp_databases] RE: How much can Access take?
I think the latest is 2.6.
Go with that
-----Original Message-----
From: kalyan_ramji@h... [mailto:kalyan_ramji@h...]
Sent: 25 July 2001 16:22
To: ASP Databases
Subject: [asp_databases] RE: How much can Access take?
Thanks Eoghan.. Any clues on my connectivity issue.. Microsoft also says
that I need to reinstall MADC and I am using IIS 4.0.. But I am not sure
as to which version of MADC I need to reinstall cos in the link given by
Microsoft there are lots. Thanks for your help..
Message #20 by "Tomm Matthis" <matthis@b...> on Wed, 25 Jul 2001 11:03:19 -0400
|
|
Thanks for the info Daniel!
-- Tomm
> -----Original Message-----
> From: Daniel Walker [mailto:danielw@w...]
> Sent: Wednesday, July 25, 2001 3:38 PM
> To: ASP Databases
> Subject: [asp_databases] RE: How much can Access take?
>
>
> All the provisos about mySQL I made to Kien on the other lsit
> still stand. No sprocs, no
> triggers, no transaction management, no a lot of things... but if
> your database work only
> involves read-only or read-and-append type work, then mySQL can
> be a lot faster than
> other alternatives. I would never want to start running an
> e-commerce site off it, but many
> sites can and could run on mySQL. You can get a lot of harware
> for the cost of some
> software licenses: which will quicken your website most -
> replacing a p100 with a Dell
> Poweredge, or installing SQL Server on the P100?
>
> Maybe you should consider using Postgre SQL? I've never used it,
> but Adam Lang on
> the Pro PHP list described it as "Open source Oracle". Adam isn't
> given to saying such
> things idly. I've heard of memory leakage problems with Postgre
> SQL in the past. These
> may have been fixed by now, however. When evaluating open source
> software, it is
> best to get impartial reviews that deal with the very latest
> distributions because
> development and improvement does tend to happen a lot faster in
> the open source world
> than elsewhere: what may have been crap six months ago maybe the
> very thing you
> need, by now. I've certainly seen PHP sites that run on Postgres
> that work like a dream.
>
> Daniel Walker
> Wrox Press
>
> > At this time mySQL doesn't support sprocs does it? Are there
> plans to add
> > that functionality in the near future?
> >
> > At work, we use MS Sql, but I am working with a non-profit
> organization that
> > would be very interested in mySQL 'cause of the $$ factor....
> but I'd really
> > miss not having sprocs...
> >
> > -- Tomm
> >
> > > -----Original Message-----
> > > From: Daniel Walker [mailto:danielw@w...]
> > > Sent: Wednesday, July 25, 2001 12:38 AM
> > > To: ASP Databases
> > > Subject: [asp_databases] RE: How much can Access take?
> > >
> > >
> > > Check out my conversation of the last few hours with Kien on the
> > > asp_database_setup list:
> > > http://p2p.wrox.com/view.asp?list=3Dasp_database_setup&id=3D86277
> > >
> > > mySQL is an alternative worth considering, if you are only doing
> > > read-only, read-and-append, or read-and-lightly-modify
> operations on your
> > > datastore. Case in point: http://p2p.wrox.com/ - the whole of
> this site's
> > > front end runs off a mySQL databse, and every page makes at least
> > > some call
> > > to the DBM... and yet it can carry four or five times the
> traffic Tomm is
> > > baulking at. (p2p has a ten minute session time-out, so the
figures it
> > > delivers on the front page approach reality, I suspect:
> earlier today it
> > > was well into the 150's-type mark and it's been at 450-500
simluateous
> > > before now.)
> > >
> > > Daniel Walker
> > > Wrox Press
> > >
> > > > 100 concurrent users!!!
> > > >
> > > > Aiyieeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee!!!
> > > >
> > > > -- Tomm
> > > >
> > > > > -----Original Message-----
> > > > > From: Marcus Hamilton [mailto:marcus@p...]
> > > > > Sent: Tuesday, July 24, 2001 9:34 PM
> > > > > To: ASP Databases
> > > > > Subject: [asp_databases] How much can Access take?
> > > > >=3D20
> > > > >=3D20
> > > > > Hi,
> > > > >=3D20
> > > > > Does anybody have any idea as to how much strain Access
> can take, and
> > > =3D
> > > > how=3D20
> > > > > any stress would manifest itself?
> > > > >=3D20
> > > > > I have an ASP site which uses serveral Access tables
> exceeding 20MB, =3D
> > > > and=3D20
> > > > > the site usually has no more than 100 concurrent users at
> any one =3D
> > > > time. I=3D20
> > > > > deal with concurrency conflicts by catching the error so that
the
> > > user =3D
> > > >
> > > > > does not see any scripting errors.
> > > > >=3D20
> > > > > Sometimes however, the ASP just fails. It fails for all the
ASP=3D20
> > > > > applications on the server, however, non-ASP pages work
> fine. The =3D
> > > > failure=3D20
> > > > > manifest itself by taking forever when a page is requested.
The=3D20
> > > > > page never=3D20
> > > > > gets displayed.
> > > > >=3D20
> > > > > Resetting the machine resolves the problem.
> > > > >=3D20
> > > > > The platform is Windows 2000 IIS5.
> > > > >=3D20
> > > > > Any ideas would be most welcome.
> > > > >=3D20
> > > > > Regards
> > > > > Marcus
> > > > >
>
Message #21 by kalyan_ramji@h... on Wed, 25 Jul 2001 16:14:27
|
|
I found out MADC 2.6 RTM, but was not able to find Jet 4 SP3 on the
Microsoft Site. I tried a search but it returned zero results. Will this
pack help me in setting up a OLEDB connection. Also, do I directly install
the MADC 2.6 RTM in the Server or is there any special proceedure? Once
again thanks for all your help.
Message #22 by "Eoghan O'Byrne" <Eoghan.O'Byrne@W...> on Wed, 25 Jul 2001 16:20:58 +0100
|
|
Hey Kalyan,
You for the connectivity you should try downloading MDAC 2.6
Regards,
Eoghan
-----Original Message-----
From: kalyan_ramji@h... [mailto:kalyan_ramji@h...]
Sent: Wednesday, July 25, 2001 4:22 PM
To: ASP Databases
Subject: [asp_databases] RE: How much can Access take?
Thanks Eoghan.. Any clues on my connectivity issue.. Microsoft also says
that I need to reinstall MADC and I am using IIS 4.0.. But I am not sure
as to which version of MADC I need to reinstall cos in the link given by
Microsoft there are lots. Thanks for your help..
---
Message #23 by "Marcus Hamilton" <marcus@p...> on Wed, 25 Jul 2001 19:41:05
|
|
Thank you all for your various responses.
I'm strongly considering moving over to SQL Server 2000.
Just one other question. Those of you who have had problems with Access
being overloaded, how did the overload manifest itself, as presumably, if
there is a similarity in the way that the system breaks down, it will make
it more easily identifiable as a problem relating to Access rather than
anything else. As I said before, every ASP application on my server
stopped working, but the non-ASP sites worked fine.
Regards
Marcus
> Could it be a problem with the network. Just curious.. Sorry if I am
> dragging this too long..
>
>
> > Hey Kalyan,
> >
> > If you found performance to decrease with 80 users then the code,
> > database or both need tuning.
> >
> > But if you still want to know of an extremely powerful database then
> > Oracle is the answer.
> > The current version is 9i.
> >
> > For a school even if the school has 2000 students SQL Server will do
> > fine especially if its only for a webboard.
> >
> > Regards,
> >
> > Eoghan
> >
> > -----Original Message-----
> > From: kalyan_ramji@h... [mailto:kalyan_ramji@h...]
> > Sent: Wednesday, July 25, 2001 2:58 PM
> > To: ASP Databases
> > Subject: [asp_databases] RE: How much can Access take?
> >
> >
> > 100 Users!! Forget 100, my school used an Access database to set up
a
> > webboard for students and we had a problem with 25 users logging on at
> > the
> > same time. The webboard admin. had to change the database to SQL
server.
> >
> > But even then, it was working fine, but when the number of users
> > increased
> > to say like 80 it slowed down too.. It was working but was slower
than
> > earlier. Can anyone tell me which is the best database that would
handle
> >
> > huuugge data and still go lightining fast?
> >
> > > At this time mySQL doesn't support sprocs does it? Are there plans to
> > add
> > > that functionality in the near future?
> > >
> > > At work, we use MS Sql, but I am working with a non-profit
> > organization
> > that
> > > would be very interested in mySQL 'cause of the $$ factor.... but
> I'd
> > really
> > > miss not having sprocs...
> > >
> > > -- Tomm
> > >
> > > > -----Original Message-----
> > > > From: Daniel Walker [mailto:danielw@w...]
> > > > Sent: Wednesday, July 25, 2001 12:38 AM
> > > > To: ASP Databases
> > > > Subject: [asp_databases] RE: How much can Access take?
> > > >
> > > >
> > > > Check out my conversation of the last few hours with Kien on the
> > > > asp_database_setup list:
> > > > http://p2p.wrox.com/view.asp?list=3Dasp_database_setup&id=3D86277
> > > >
> > > > mySQL is an alternative worth considering, if you are only doing
> > > > read-only, read-and-append, or read-and-lightly-modify operations
on
> >
> > your
> > > > datastore. Case in point: http://p2p.wrox.com/ - the whole of
this
> > site's
> > > > front end runs off a mySQL databse, and every page makes at least
> > > > some call
> > > > to the DBM... and yet it can carry four or five times the traffic
> > Tomm
> > is
> > > > baulking at. (p2p has a ten minute session time-out, so the figures
> > it
> > > > delivers on the front page approach reality, I suspect: earlier
> > today
> > it
> > > > was well into the 150's-type mark and it's been at 450-500
> > simluateous
> > > > before now.)
> > > >
> > > > Daniel Walker
> > > > Wrox Press
> > > >
> > > > > 100 concurrent users!!!
> > > > >
> > > > > Aiyieeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee!!!
> > > > >
> > > > > -- Tomm
> > > > >
> > > > > > -----Original Message-----
> > > > > > From: Marcus Hamilton [mailto:marcus@p...]
> > > > > > Sent: Tuesday, July 24, 2001 9:34 PM
> > > > > > To: ASP Databases
> > > > > > Subject: [asp_databases] How much can Access take?
> > > > > >=3D20
> > > > > >=3D20
> > > > > > Hi,
> > > > > >=3D20
> > > > > > Does anybody have any idea as to how much strain Access can
> > take,
> > and
> > > > =3D
> > > > > how=3D20
> > > > > > any stress would manifest itself?
> > > > > >=3D20
> > > > > > I have an ASP site which uses serveral Access tables
exceeding
> > 20MB, =3D
> > > > > and=3D20
> > > > > > the site usually has no more than 100 concurrent users at any
> > one =3D
> > > > > time. I=3D20
> > > > > > deal with concurrency conflicts by catching the error so that
> > the
> > > > user =3D
> > > > >
> > > > > > does not see any scripting errors.
> > > > > >=3D20
> > > > > > Sometimes however, the ASP just fails. It fails for all the
> > ASP=3D20
> > > > > > applications on the server, however, non-ASP pages work fine.
> > The =3D
> > > > > failure=3D20
> > > > > > manifest itself by taking forever when a page is requested.
> > The=3D20
> > > > > > page never=3D20
> > > > > > gets displayed.
> > > > > >=3D20
> > > > > > Resetting the machine resolves the problem.
> > > > > >=3D20
> > > > > > The platform is Windows 2000 IIS5.
> > > > > >=3D20
> > > > > > Any ideas would be most welcome.
> > > > > >=3D20
> > > > > > Regards
> > > > > > Marcus
> > > > > >
Message #24 by "Ken Schaefer" <ken@a...> on Thu, 26 Jul 2001 13:06:05 +1000
|
|
http://www.microsoft.com/data/download.htm#Jet4SP3info
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
----- Original Message -----
From: <kalyan_ramji@h...>
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, July 25, 2001 4:14 PM
Subject: [asp_databases] RE: How much can Access take?
: I found out MADC 2.6 RTM, but was not able to find Jet 4 SP3 on the
: Microsoft Site. I tried a search but it returned zero results. Will this
: pack help me in setting up a OLEDB connection. Also, do I directly install
: the MADC 2.6 RTM in the Server or is there any special proceedure? Once
: again thanks for all your help.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Message #25 by "Ken Schaefer" <ken@a...> on Thu, 26 Jul 2001 13:23:17 +1000
|
|
2.6 does not include Jet OLEDB providers, or Desktop Database ODBC drivers.
YOu need to either download MDAC v2.5 SP2, or MDAC v2.6 plus the additional
Jet SP3
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
----- Original Message -----
From: "Sam Clohesy" <sam@e...>
To: "ASP Databases" <asp_databases@p...>
Sent: Thursday, July 26, 2001 12:38 AM
Subject: [asp_databases] RE: How much can Access take?
: I think the latest is 2.6.
: Go with that
:
: -----Original Message-----
: From: kalyan_ramji@h... [mailto:kalyan_ramji@h...]
: Sent: 25 July 2001 16:22
: To: ASP Databases
: Subject: [asp_databases] RE: How much can Access take?
:
:
: Thanks Eoghan.. Any clues on my connectivity issue.. Microsoft also says
: that I need to reinstall MADC and I am using IIS 4.0.. But I am not sure
: as to which version of MADC I need to reinstall cos in the link given by
: Microsoft there are lots. Thanks for your help..
:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Message #26 by kalyan_ramji@h... on Thu, 26 Jul 2001 17:57:43
|
|
Thanks Ken. Will try that out and see whether it works.. Thanks again.
-Kalyan..
Message #27 by David Cameron <dcameron@i...> on Fri, 27 Jul 2001 10:08:25 +1000
|
|
Nobody has mentioned MSDE so far. If you don't have SQL Server already
then
there are problems (ie no client tools), but I guess it is possible to
live
with that.
regards
David Cameron
nOw.b2b
dcameron@i...
-----Original Message-----
From: Tomm Matthis [mailto:matthis@b...]
Sent: Wednesday, 25 July 2001 8:42 PM
To: ASP Databases
Subject: [asp_databases] RE: How much can Access take?
At this time mySQL doesn't support sprocs does it? Are there plans to
add
that functionality in the near future?
At work, we use MS Sql, but I am working with a non-profit organization
that
would be very interested in mySQL 'cause of the $$ factor.... but I'd
really
miss not having sprocs...
-- Tomm
> -----Original Message-----
> From: Daniel Walker [mailto:danielw@w...]
> Sent: Wednesday, July 25, 2001 12:38 AM
> To: ASP Databases
> Subject: [asp_databases] RE: How much can Access take?
>
>
> Check out my conversation of the last few hours with Kien on the
> asp_database_setup list:
> http://p2p.wrox.com/view.asp?list=3Dasp_database_setup&id=3D86277
>
> mySQL is an alternative worth considering, if you are only doing
> read-only, read-and-append, or read-and-lightly-modify operations on
your
> datastore. Case in point: http://p2p.wrox.com/ - the whole of this
site's
> front end runs off a mySQL databse, and every page makes at least
> some call
> to the DBM... and yet it can carry four or five times the traffic
Tomm is
> baulking at. (p2p has a ten minute session time-out, so the figures
it
> delivers on the front page approach reality, I suspect: earlier today
it
> was well into the 150's-type mark and it's been at 450-500
simluateous
> before now.)
>
> Daniel Walker
> Wrox Press
>
> > 100 concurrent users!!!
> >
> > Aiyieeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee!!!
> >
> > -- Tomm
> >
> > > -----Original Message-----
> > > From: Marcus Hamilton [mailto:marcus@p...]
> > > Sent: Tuesday, July 24, 2001 9:34 PM
> > > To: ASP Databases
> > > Subject: [asp_databases] How much can Access take?
> > >=3D20
> > >=3D20
> > > Hi,
> > >=3D20
> > > Does anybody have any idea as to how much strain Access can take,
and
> =3D
> > how=3D20
> > > any stress would manifest itself?
> > >=3D20
> > > I have an ASP site which uses serveral Access tables exceeding
20MB, =3D
> > and=3D20
> > > the site usually has no more than 100 concurrent users at any one
=3D
> > time. I=3D20
> > > deal with concurrency conflicts by catching the error so that the
> user =3D
> >
> > > does not see any scripting errors.
> > >=3D20
> > > Sometimes however, the ASP just fails. It fails for all the
ASP=3D20
> > > applications on the server, however, non-ASP pages work fine. The
=3D
> > failure=3D20
> > > manifest itself by taking forever when a page is requested.
The=3D20
> > > page never=3D20
> > > gets displayed.
> > >=3D20
> > > Resetting the machine resolves the problem.
> > >=3D20
> > > The platform is Windows 2000 IIS5.
> > >=3D20
> > > Any ideas would be most welcome.
> > >=3D20
> > > Regards
> > > Marcus
> > >
|
|
|
View Cart
