| Author |
 Topic  |
|
|
Intrepidone
Average Member
Canada
515 Posts |
 Posted - 24 May 2001 : 10:11:06
|
My site is still running on an Access db and I thought it could only handle around 6 to 8 concurrent connections.
I went to the site and all toll there were 14 (including myself) 11 were from the same IP (except for the last 3 numbers) so I am thinking it was a spider.
Now, even though this spider connected with 11 different IP's, would that count as 11 connections or just 1 to the Access db?
pic of online users stats
Intrepidone |
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 24 May 2001 : 12:28:36
|
Actually, it's probably 0 access users. Unlike a LAN Access application, connections are transient in a asp application. Your asp page opens a connection to the database, does it's stuff, and closes the connection before the web browser displays all the page.
In addition, a properly configured web server, the connections to the database are 'pooled' where a single connection can be effectively shared by many web pages.
Access itself has a limit of I think 250 users. I've always heard the reality for a LAN-based application is in the range of 20 or so users, but I know of 100+ LAN user installs that work.
Your ADO provider configuration can impact the number of users as well. There are settings for buffer size, thread counts and so forth that can impact the effective user count.
======
Doug G
====== |
 |
|
|
Intrepidone
Average Member
Canada
515 Posts |
Posted - 24 May 2001 : 14:08:54
|
Thanks Doug,
That clears up alot of what I did not know about Access. I was going to do a site with SQL Server, but now that I know Access should handle things ok for now, I'll slowly work on creating a site using SQL Server.
Intrepidone |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 24 May 2001 : 17:43:59
|
You're welcome!
======
Doug G
====== |
|
|
| |
Topic |
|
Topic Locked
