alistairbayley

I still have one of their t-shirts.

How big is your database, and how long does it take to restart? We have what I would describe as a fairly small influx database, and it takes a long time to restart (20-30 mins). And the time to restart seems to be growing linearly with the db size. Not cool if you do regular server patching with reboots.

We also had a problem where user queries that return too many columns cause the DB server process to OOM. And then it restarts, so another 20 mins of downtime. Also not cool.

We liked the tagging and rollup features, and automatic retention management, but those first 2 problems really turned us off.

You could look at it like this: the goal is to reduce the total number of sick says in the pool, however you do it. A pooled allowance might encourage people more to stay away from work when ill.

A given individual may not have much control over whether or not they get sick, but then can influence whether or not they share that illness with their colleagues. The individual allowance has a stronger incentive to return to work vs the pool, because there is no cost to the individual if their colleagues become ill. With a pooled allowance, there is a cost to the individual if they make their colleagues ill.

1. Why indent the joins? Are table2 and table3 less important than table1? Is table1 special? Is that why it enjoys privileged status in the from-clause?

2. Why place some predicates in the where-clause and others in the join-clauses? What's the thinking here? Why not put all predicates up in the join-clauses, nearer to the tables that they affect?

Re uppercase: can't afford a syntax-highlighting editor?

What's so amazing about it, when compared to the other SQL DBMS's? (e.g. postgresql, oracle, sybase, db2, etc)

Especially as it's just a re-badged Sybase...

I think the nested intervals model, a refinement of nested sets, solves this slow update problem: http://www.rampant-books.com/art_vadim_nested_sets_sql_trees...

But I've never had to use it, so I am just guessing.

Same article, different site: https://communities.bmc.com/docs/DOC-9902

And a paper: http://www.sigmod.org/publications/sigmod-record/0506/p47-ar...

Here's a comparison of the different approaches in a matrix: http://vadimtropashko.wordpress.com/2008/08/09/one-more-nest...

How does this compare to Mr Social? : http://mobisocial.stanford.edu/papers/mrprivacy.pdf