We actually have a hardware load balancer that is collecting dust because I had already written oodles of cold fusion using sessions and getting primary keys from MS SQL Server by "select max(primaryKey) + 1".
The load balancer doesn't have the option to use cookies to keep users on the same server. That option cost $4,000 :). Cold Fusion does support database storage of session variables, called client variables. That would solve the session problem. The other problem is that SQL Server doesn't have Sequences. Hal Helms, a CF guru, writes that to overcome this, just use GetUUID() to create primary keys that are almost guaranteed to be unique across the entire world. The downside is that those primary keys are 35 bytes long. Yuck. I'm curious how others simulate sequences on MS SQL Server and similar databases. Server side locking of tables during inserts? I'm still reading that etoys clustering article. Good stuff! -Jeff _______________________________________________ Webware-discuss mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/webware-discuss
