Mohawksoft,
> One of the most common SQL database applications is as the backend of some
> higher level system, like a web site. In these systems, ususlly done in
> Java, PHP, or heaven help us, .NET, you have multiple front end machine
> communicating with a SQL database backend.
Leaving aside that Java, .NET and even PHP5 have much more sophisticated ways
of sharing variables ...
> These systems use the database as the main data server. The overall
> scalability of their system is based on the scalability of the database.
> At some point, you'll max out the DB and be stuck. The shared variables
> module is designed to allow you to scale better by allowing you to cheapy
> maintain data.
I really don't follow how this makes a lack of transaction-awareness for these
global variables an advantage. If you're saying that it's not possible to
make shared variables which are both cheap and transaction-aware, then say so
and be clear about it.
Please understand that I am not opposed to the idea behind the shared variable
proposal. I just think there are some details to be worked out.
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco