DATABASE DRIVEN WEBPAGE!!

[TechJumper]

I have a web page that provides news. It must constantly be updated throughout the day. It seems like a reasonable move to use database technology. Who is the best for this? Who does SysOpt use, if any? Is it Oracle, your suggestions are welcome.

Best,

Michael Morelli

[rh71]

Honestly, it sounds like you can get away with using MS Access as your database. Cost effective (you probably have it already) and simple to setup. It really depends on how much and how often it will get hit at any given time.

[stodge]

What platform? If its Linux, Postresql or Mysql. I use Mysql (http://www.stodge.net - plug plug!)

Also, how much traffic do you expect? i.e. what performance do you need?

[TechJumper]

I THINK (stats come from counter.com) get approx 215 hits per day. Does MS ACCESS have the requirements to handle that traffic?? If so, where can I go to set up that database?

Thanks for everything,

Mike

[Missing the point]

Talk to Bkehoe, he uses Databases for his webpage I think ( http://www.techgear.net )


He should know

[TechJumper]

What a wonderful site. And NEW! cool. hey a tech I bother all the time from microsoft put this site up www.dopplegangers.com. (http://www.dopplegangers.com.) I honestly don't know what it is about. Mostly gaming, but It is database driven.

mike

[vass0922]

I would think Access would be fine for you.
I'm not sure how much traffic it can handle but to my understanding as long as your DB isn't over a gig you'll be fine (this is where Access dies).
You could probably fairly easily set up a page using ASP recordsets to make calls to the DB. ASP is based on VB so it's pretty easy to use once you get the hang of it.

[Brian48]

NO. Access is only fine if you are using it to manually update the site (ie. having it generate the pages and then you FTP'ing them over). If you plan to have .asp pages hitting the database everytime a user queries a topic, it will choke on you and you risk losing everything. The biggest limitation of Access is the number of concurrent users allowed. It is not very robust in this regard and was not meant for use as a wide scale, enterprise solution. Even Microsoft will tell you this and will recommend you use SQL Server instead.