Is access restricted?

Is access restricted? (Full Version)

All Forums >> [Web Development] >> ASP and Database

Message

Stuart at Cherry -> 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*

Spooky -> RE: Is access restricted? (3/26/2001 20:19:00)
Initially, use Access to set up your pages and queries. Keep in mind that you may need to upsize to SQL at a later date. Weve just done that with our template sales site on the link up top. The Access database wasnt reliable enough in that instance. Mainly because the shop code hits the database real hard. Its really one of the unknowns as to how it will react. My login database was running quite well on the same server. So milage may vary

Mojo -> 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

hzarabet -> 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 -> 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.

Page: [1]

Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.0625