[Kroupware] OpenGroupware.org formed through SKYRiX open sourcing its Groupware server

[Helge Hess]

On Sonntag, 13. Juli 2003, at 2:21 Uhr, Helge Hess wrote:
>> Seems like it'd scale _wonderfully_ well.
>
> I don't see how.
>
> Simple calculation: 1000 users each having 1000 appointments, 100 
> jobs, 100 contacts and 4000 messages - 20 attributes in average, which 
> is few. The properties table will have to deal with 1000 x 1000 x 100 
> x 100 x 4000 x 20 rows:
>   800.000.000.000.000
>
> No wonder it's slow even for 10 users.

Ups, just discovered this is a buggy calculation ;-) Correct:
   1000 * (1000 + 100 + 100 + 4000) * 20
still
   104 Million Rows

which still isn't the "normal" number of rows a RDBMS is supposed to 
handle.

regards,
   Helge
-- 
OpenGroupware.org	- http://www.opengroupware.org/