Leon Rosenberg wrote: >> Von: Michael Jouravlev [mailto:[EMAIL PROTECTED] >> >> On 7/25/05, Leon Rosenberg <[EMAIL PROTECTED]> wrote: >> > I think the problem is rather that none of the dbs scales. >> > To scale you need something in front of db in the business layer >> > (middleware), so it's no difference whether you use ibatis or sql. >> > Could be nasty with hibernate though, at least you need to turn off >> > the lazy loading...
Surely that's entirely dependent on the type of transactions you're doing. I would expect lazy loading to help with scalability in some cases. >> >> I thought that database clusters exist before J2EE clusters >> ;) And I believe that former are more robust than latter too. > > Database clusters exists, true. But who tells you that they scale??? > > Actually I has often seen projects, where the architect told, if we will > have scalability problems, we will cluster the db. > Then, the day X came, they clustered the db and then... surprise, surprise > it became even slower... > > I think the sentence "clustering will help you scaling" is an urban myth > :-) It's hard to see where clustering is ever going to be more efficient than a single multi-cpu machine of the same capacity. The cluster only helps when you get into realms beyond the reach of a single machine, and generally where that machine is cpu-bound. Clusters have their place, but I'm still not sure it's in DBs. -- derek --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
