SteveS
Posts: 41
|
| Posted: 03/05/2004, 1:44 PM |
|
Hi,
Is anyone aware of any possible limitations when running access 2000/asp and iis?
I know there are loadsa things to look at like hardware spec etc. I would like to know if say 30 users is a realistic limit etc.
Thanks, Steve.
|
 |
 |
peterr
Posts: 5971
|
| Posted: 03/05/2004, 2:23 PM |
|
We utilize ASP with MS Access at http://support.codecharge.com/ and http://support.codecharge.com/kb_search.asp, and previously at http://www.gotocode.com
This is actually as proof of concept, to see if or when ASP with MS Access may start failing, at which time we could look for solutions to improve CCS, or switch to MS SQL. No problems so far though.
10 users at the same time is generally the limit for MS Access, but all users are treated the same, which basically means 10 page views at the same time, or rather 10 SQL queries at the same time.
From a different point of view, usually the data is read from the database within one second (unless you are performing a long search), therefore potentially you could serve 10 page views in a second, which means up to 600 page views in a minute, which comes to 36000 page views in an hour. In practice I wouldn't plan on more than 5000 page views per hour.
A separate issue are long searches. For example if there are a lot of records that are searched and one search takes several seconds, then the other page views are often delayed until the search is finished.
Using the latest JET driver may help in improving the performance. Not sure about ODBC, but I see JET being updated more frequently and certain issues were resolved in the last couple years.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Bill Noble
|
| Posted: 03/07/2004, 6:57 AM |
|
There is an article published by Microft Technical
"Understanding the Differences Between SQL Server and Microsoft Access"
Check it out at:
www.web-presentations.com
Information sheet number 73 in the developer area.
Regards
Bill
|
|
|
|
Oper
Posts: 1195
|
| Posted: 03/09/2004, 9:53 PM |
|
I think you coudl have more than 200+ user conect to a access 2002 database.
The real limit more comon is that when you are using IIS in a none Server OS for example, XP, 2000 Terminal, etc teh concurrent conection at 1 time is 10 (we tested a XP server with 25 user clicking at once and belive even with the limitation to XP for only 10 conection we didnt noticed any delayed :) )
another could be uncheck the keep conection alive!
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
peterr
Posts: 5971
|
| Posted: 03/09/2004, 10:59 PM |
|
The limit of 10 users was a known fact some time ago. It's possible that the newer JET drivers support 200+ users but as Oper pointed most articles about MS Access talk about its limitations on the desktop, not when accessed from ASP via the JET driver.
And in practice I'm not exactly sure if the user limit is much relevant because we do experience delays when long queries are being executed. For example if one page is pulling data via a query that takes long time, let's say 2 seconds, then the pages accessed by other visitors are delayed and not displayed until the query is finished, 2 seconds later. This shows that possibly MS Access is unable to handle multiple queries in parallel, possibly just one. Proper indexing may help.
Currently our only problem is very slow performance when searching 10s of thousands of records for text using LIKE %keyword%. When several people do this, some of them may be waiting half a minute for their results. This is where MS Access truly reaches its limits and the the "2 GB" database size limit or 255 concurrent users is just a nice theory.
Therefore I think that every application may work little differently with Access, and depends on the type of queries being exectued and the number of records in the commonly used tables. It's actually best to test your own application with your own hardware and with your own drivers (preferrably the latest).
Though I still think that generally projecting about 5000 page views per hour (1.5 per second) for a non-search intensive, properly indexed database is safe, which comes to 50000 in a day counting ~10 peak hours, which in turn comes to 1.5 million a month. This is already quite not bad for MS Access. Now imagine what MS SQL can do 
BTW, in the past we have experienced actual database lockups & crashes when more than 10 users were accessing pages at the same time. I haven't seen this problem reoccuring in over a year, which means that possibly our admin updated the JET driver or performed other server maintenance.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Oper
Posts: 1195
|
| Posted: 03/10/2004, 6:11 AM |
|
peterr wrote:
properly indexed database is safe
that is really the key!
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
DonB
|
| Posted: 03/10/2004, 3:09 PM |
|
More important may be the limitation on database SIZE. Access will limit
the file size to 2GB (even Access 2000). That's not hard to hit. I tried
creating a test database recently with a single memo field containing about
100 bytes of text plus a handful of other fields - it reached the filesize
limit with only about 30000 records.
--
DonB
http://www.gotodon.com/ccbth
"SteveS" <SteveS@forum.codecharge> wrote in message
news:64048f4d5907b9@news.codecharge.com...
> Hi,
>
> Is anyone aware of any possible limitations when running access 2000/asp
and iis?
>
> I know there are loadsa things to look at like hardware spec etc. I would
like to know if say 30 users is a realistic limit etc.
>
> Thanks, Steve.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Oper
Posts: 1195
|
| Posted: 03/11/2004, 7:12 AM |
|
30000 is a bit low, i will run that test too. in 2003 and let see!
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
Oper
Posts: 1195
|
| Posted: 03/11/2004, 11:15 AM |
|
added a 2nd forum  casue i did new Topic by mistake and i was quick anyway Steves check here:
http://forums.codecharge.com/posts.php?post_id=44258
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
|
