[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: perf question 100,000 directories vs 1 directory



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.


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 10/20/06 13:21, misc@imerk.net wrote:
> Hello,
> 
> I'm working on a database application. We're going to have multiple
> logins, say 100,000.

By "logins", do you mean "user accounts"?

> Performance wise would we see a difference if we had 100,000
> directories with each users database in its own directory, versus
> having 1 directory with all 100,000 databases in that single
> directory?

????  100,000 databases????

The purpose and idea of database engines is that you can combine all
the separate user data into *one* database.

- --
Ron Johnson, Jr.
Jefferson LA  USA

Is "common sense" really valid?
For example, it is "common sense" to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However, that "common sense" is obviously wrong.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)

iD8DBQFFObZKS9HxQb37XmcRAsBxAKDA370IZELu9CKMpsagZQMcoksFWgCgtH41
e22wKHO+hL8ov+bd2b9op8E=
=t7he
-----END PGP SIGNATURE-----


-- 
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org 
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org


Reply to: