-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 12/21/06 16:41, Joshua D. Drake wrote:
>>>> 3) Put each customer in their own schema/namespace which resides within
>>>> its own table space.
>>>>
>>>> Then you can move customers wherever you need in terms of IO.
>> How is that functionally different than using a separate database? What's the
>> advantage here? I don't *need* to restrict myself to one database, and doing
>> this does require that I revisit 100% of the SQL queries to make sure that
>> I'm referencing the right schema.
>>
>> This solution seems to have the same problems as using dynamic tablenames.
>
> Not really. You should read up on schemas and how they work. Plus the
> addition of schemas and table spaces means you can infinite scaling
> within the confines of your hardware itself.
"infinite scaling within the confines of your hardware"!
How is that accomplished?
- --
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.6 (GNU/Linux)
iD8DBQFFixCWS9HxQb37XmcRAnw/AJ4obPHIHvJcRKq1xzILN7YtKfQscACg1uaq
c6FRxkXjP/Pneyy1lxA+Dl8=
=iFX6
-----END PGP SIGNATURE-----
