 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
.NET Forum / ASP.NET / General / March 2008small data needed - suggestions?
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! 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. >I am doing a funeral home page (depressing huh?) :) > [quoted text clipped - 11 lines] > > Thanks! In your opinion what is "RARE" writes? 5 or less concurrent? > For something with RARE writes...and many reads..you can get by with > either [quoted text clipped - 30 lines] >> >> Thanks! 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. ... > In your opinion what is "RARE" writes? 5 or less concurrent? > [quoted text clipped - 32 lines] >>> >>> Thanks! 1 db per deceased person? Or 1 db record? > 1 per minute?? > [quoted text clipped - 46 lines] >>>> >>>> Thanks! Sorry, I mispoke. One db per person would be too much. Look at my blog...and you could easily start with 1 db. And then use the Factory method to even use multiple Access(Jet) database files (.mdb). Like use the key system, and base it on the person's first letter of their last name. THe factory pattern gives you options. A-I (obituarydb1.mdb) J-R(obituarydb2.mdb) S-Z(obituarydb3.mdb) or start with 1 .mdb and only go to N .mdb's if you need to. > 1 per minute?? > [quoted text clipped - 46 lines] >>>> >>>> Thanks! hmmm i never heard of the factory method - i must read up on it - THANKS SLOAN!!!! > Sorry, I mispoke. > [quoted text clipped - 64 lines] >>>>> >>>>> Thanks! I have a blog entry that is ~just~ about the Simple Factory pattern as well. http://sholliday.spaces.live.com/Blog/cns!A68482B9628A842A!126.entry > hmmm i never heard of the factory method - i must read up on it - THANKS > SLOAN!!!! [quoted text clipped - 67 lines] >>>>>> >>>>>> Thanks! > 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. In addition to Sloan's comments, what's stopping you creating the two tables you suggest in an existing SQL Server database...?  SignatureMark Rae ASP.NET MVP http://www.markrae.net To be honest, I like the simplicity of having the data in 1 file, an mdb. It's easy to backup and move around. I'm a small fry developer. :) >> 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. > > In addition to Sloan's comments, what's stopping you creating the two > tables you suggest in an existing SQL Server database...? >>> 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 [quoted text clipped - 5 lines] > To be honest, I like the simplicity of having the data in 1 file, an mdb. > It's easy to backup and move around. Er, OK... SignatureMark Rae ASP.NET MVP http://www.markrae.net Or store it in a xml file >>>> 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 [quoted text clipped - 7 lines] > > Er, OK...
Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.