Re: small data needed - suggestions?
- From: "sloan" <sloan@xxxxxxxxx>
- Date: Tue, 4 Mar 2008 11:11:49 -0500
1 per minute??
Just not an overloaded amount of simutaneous writes.
Since this is a web app (I'm assuming)...then the web server talking to an
Access(JET) database locally..is not that big of a deal.
Access can handle a light load of 5-10 simutanaeous users in my opinion.
Your obituary thing...if you have 1 db per deceased person....would be fine
for this imho.
....
"Bobby Edward" <test@xxxxxxxx> wrote in message
news:egWJ$DhfIHA.5260@xxxxxxxxxxxxxxxxxxxxxxx
In your opinion what is "RARE" writes? 5 or less concurrent?
"sloan" <sloan@xxxxxxxxx> wrote in message
news:OwuaUAhfIHA.5620@xxxxxxxxxxxxxxxxxxxxxxx
For something with RARE writes...and many reads..you can get by with
either
Access (Jet) (.mdb)
or
SqLite
I'm working on a prototype using the FActory Pattern and supporting
multiple RDBMS.
Go here
http://sholliday.spaces.live.com/Blog/
or
http://sholliday.spaces.live.com/Blog/feed.rss
(search for "multiple rdbms")
and if I don't have it up yet...email me and I'll send you a copy.
"Bobby Edward" <test@xxxxxxxx> wrote in message
news:%23p9PH%23gfIHA.1184@xxxxxxxxxxxxxxxxxxxxxxx
I am doing a funeral home page (depressing huh?) :)
They want an obituary page where people can post comments. So, in my db
I have 2 tables (1 to many relationship)...
TABLE1: Obituary (persons info)
TABLE2: ObitComments ("many" table - comments)
There would be an admin page to approve or reject comments, manage
obituaries, etc...
My ISP only allows me a certain # of SQL Server dbs. I would hate to
"waste" one on a small project like this. Any suggestions? How would
you handle it? SQL Express is not supported either.
Thanks!
.
- Follow-Ups:
- Re: small data needed - suggestions?
- From: sloan
- Re: small data needed - suggestions?
- From: Bobby Edward
- Re: small data needed - suggestions?
- References:
- small data needed - suggestions?
- From: Bobby Edward
- Re: small data needed - suggestions?
- From: sloan
- Re: small data needed - suggestions?
- From: Bobby Edward
- small data needed - suggestions?
- Prev by Date: Re: small data needed - suggestions?
- Next by Date: Server.Transfer exception in master page
- Previous by thread: Re: small data needed - suggestions?
- Next by thread: Re: small data needed - suggestions?
- Index(es):
Relevant Pages
|