----- Original Message ----- From: Roberto C. Sanchez To: debian-user@lists.debian.org Sent: Sat, 21 Oct 2006 02:08:50 -0400 Subject: Re: perf question 100,000 directories vs 1 directory
On Fri, Oct 20, 2006 at 11:03:12PM -0700, [EMAIL PROTECTED] wrote: > I believe the reason we're using individual databases is for marketing > purposes. aparently being > able to say its a single tenent application is a selling point. > > Although if its going to be too problematic we may switch to a single db. > If you use a standard database (I'm familiar with Postgres, so that is what I will use for an example), you can create a single DB cluster that contains many databases. Based on access restrictions, each database can be "single tenant" since you must create the database and the user and then provide rights. Or you can create the user and then the database, making the user the owner of that databse. Regards, -Roberto ---- I'll have to mention that. I've use postgres before as well... more then i've use sqlite. I'll have to see what other reasons there are for using doing it this way. I'm not the one who came up with this architecture. I'm just trying to find the best system to implement it. Although they arent opposed to making changes at this stage, so its definitely something i will discuss with them. thanks for the feedback Ian
