09-06-2007, 05:00 PM
hello.. not a coding problem but an interesting question..
for me I enjoy using ASP and linking to ACCESS.. its easy and simple.. but recently I have been designing and coding for larger companies.. I am just about to create a site but that gets over 5000 clicks aday..
is it a wise idea to design and construct a site with high traffic in ASP using ACCESS ??
I have used .NET but i find it too corporate and i love ASP for its fexibility,, i think if i do expand PHP would be my choice ??
your input on this would be great ...
09-06-2007, 05:30 PM
if you're expecting that high number of visitors and you will be accessing data from a database, you would be wise not to use Access and look at either MSSQL or MySQL. Although .NET is the up and coming thing there is nothing saying that you can't develop the site in ASP. Your concern is really only the database being used.
09-06-2007, 06:17 PM
Using Access on a site that gets a large volume of hits is definately not the way to go. One of Access' limitations is the number of concurrent connections. Access has a limit of 7 concurrent connections. So while it is possible that with 5000 hits a day that most people will have no problem, the user who happens to make a request at the exact same time as 7 other people do could be shown an error. Definately pick a more robust database.
Depending on who does the hosting MySQL may be available and if so it is a much better option than Access. However many webhosts don't have MySQL on their windows machies but do have MS SQL Server.
Plus MySQL and SQL Server offer advantages like stored procedures, and user defined functions that are not found in Access.
09-10-2007, 02:30 PM
Access has a limit of 7 concurrent connections
I've heard a lot of numbers for how many Access supports. Usually between 12-15. But I've never seen anything that looks official, and I've never heard 7. I'm not doubting you - I agree entirely that it'll fall over if you try to run anything... "commercial" scale... but if you could point me at something that I could use when trying to talk people out of running sites off Access, I'd be very grateful :)