|
| |
|
|
Stuart at Cherry
Posts: 121
From: Leeds, West Yorkshire, UK
Status: offline
 |
Is access restricted? - 3/26/2001 20:03:00
I run a recruitment company and I have a couple of websites up that have, amongst other things, a list of current vacancies. At the moment they are just type copy in tables, and they look fine. But what I'd like to do is put them in a database so that potential candidates can search them etc. You know the kind of thing from your own searches for jobs!Anyway, I'm going to go ahead and see what I can do with the database wizard, having read the articles posted on this site. However, I have read somewhere that Access as a database is very slow on the web. We don't host the sites ourselves, they are hosted by an ISP. I'm sure I read somewhere that if more than 30 queries were run on your server at any one time then it would freeze altogether. I'm fairly sure that I wont have 30 queries running at once on my site, but I have no control over other sites hosted on the same server as my site. Is this an issue? Anyone have any comments? Should I be using a different DB? Etc. All responses appreciated. ------------------
***born to be wild***
|
|
|
|
Mojo
Posts: 2431
From: Chicago
Status: offline
|
RE: Is access restricted? - 3/26/2001 16:48:00
I have a niche recruitment site where employers can search for resumes. I don't have that much traffic, but Access2000 works very good... for now.It is much cheaper to go with Access and see how well it works. I read everything I could about the 20-30 concurrent user limitation with Access. The limit seems low at first, but when you figure 1 second for the connection time (this can vary higher or lower depending on many things) you have 25 users per second. 100 users for 4 seconds, 2500 users can connect in 10 seconds etc... If you have done any online recruiting with tools such as Monster.com, you will remember many, many, times where the search kind of spins for several seconds before your results come up? They are experiencing the same problem. Especially on Monday mornings... they can get very slow. I am not sure what database that run, but I am sure they are not using Access ![]("http://www.frontpagewebmaster.com/ubb/smile.gif")
| |
|
|
|
hzarabet
Posts: 1539
From: New Milford CT USA
Status: offline
|
RE: Is access restricted? - 3/26/2001 17:03:00
I am of the belief that when they say 30 users, they mean on the whole SERVER. On a shared server with 500 other websites, many with Access databases, that 30 number can be reached pretty quickly. You will get an error message, not just a slow load. I've been there! Try Access first. If is isn't cutting it, then move up to SQL.------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada
| |
|
|
|
Spooky
Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Is access restricted? - 3/26/2001 21:54:00
MS try hard not to even mention how many users access will handle, mot of it is pure assumption. The fact is, it wasnt designed as a web database.
I read somewhere a guy that was getting a million hits a month with access, I havent done the math, but it sounds a lot Its not just the concurrent user thing, its also how efficient the code is, the way you open and close the database etc.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
