Matthew: That's why I go to the experts. It is an easy call with VFP tables. I have been doing it so long and it has been very successful. I set up some test sites in PostGreSQL and it's not bad but for MS SQL Server on a customer site I think the DBA's will kind of frown on my multi-site approach. Also, I have heard horror stories of an e-commerce web site where data from one site accidentally was made available to another customer.
Performance is not an issue. Overhead to program reports and CRUD forms and security are the main issues. Jeff Jeff Johnson [email protected] SanDC, Inc. 623-582-0323 Fax 623-869-0675 Jarvis, Matthew wrote: >> -----Original Message----- >> From: [email protected] > [mailto:[email protected]] >> On Behalf Of Jeff Johnson >> Sent: Wednesday, February 17, 2010 3:39 PM >> To: [email protected] >> Subject: Database Design Question >> >> Looking for opinions here. Most of my customers have several sites. >> With VFP I always put different sites in different folders so each > site >> has identical databases. When considering SQL Server or PostGreSQL >> multiple databases seems cumbersome. The other option is to have one >> database with one set of tables and have a site field. The problem > with >> this approach is that there is a chance that a mistake could make one >> site's data available to another site. There is a lot of overhead for >> printing reports and accessing data to keep thing separate. >> > > Having one DB does seem like a more sophistimicated approach, and at > least you would *know* that your schema matched across all sites.... > > BUT you're right - one man's 'cumbersome' is another mans 'security'.... > > Tough call, but if performance is an issue, as you already know the > smaller the tables, the better... > > Matthew Jarvis || Business Systems Analyst > IT Department > McKenzie-Willamette Medical Center > 1460 G Street, Springfield, OR 97477 || Ph: 541-744-6092 || Fax: > 541-744-6145 > _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
