Posts by roselan

Re: He is giving a talk about mavern

"blokes still think of women as trophies; rather than partners who they love dearly and are proud of them for who they are."

Does that mean you favor men who want several women as partners?

Moreover, you express what *you* want in men, and assume that most "blokes still think of women of trophies". This is so degrading for men!

No, I'm not nagging. Or maybe just a bit ;)

Re: Tuning Pack

There is a shitload of features in oracle. Each version brings it's own layer, and it's own bag of issues. Triggers overhead, buffer groups, result cache latches, sql plan management hidden plans (and defaults), compilation level messing error lines, hprofiler inconsistent results, FAQ (fracking advanced queuing) etc.

The cost based optimizer first aim, based on histograms, was to address skewed data. But even now it's wonky when data is extremely skewed, or when bind peeking is used. or involves date columns, or etc. It can be argued it's a design issue. As well, oracle can't seem to understand alone that data spread among blocks is critical to throughput.

And yet sqlplus still doesn't support unicode chars, there is no tool to spread a query on 10 or 100 db and aggregate the result, sql developer is a nightmare. Editions are heavy. And I forget a truck of bothering stuff, or two.

Then we can discuss spin gets counted as "on cpu" when oracle invoice their thing as "per cpu".

But the main performance issue is usage. Most databases, sadly, do both oltp and olap. The first require response time, the second throughput. And both requirements are mutually exclusive.

Funilly enough, the same debate happens at cpu level, and that's why there are things like hsa, phy, BIG.little, denver/kepler (not sure about nvidia), BOC/lic.

In the database world this result in stuff like storm/hadoop and other multi-tier db configurations. When you know what data *really* needs acid transactions, you can design a database that is *real* fast. Things like cc payments are done through a webservice, and programatically. I have yet to see dmbs_xa used for that kind of stuff, so you lose db "acidity" anyway. But even if you know the overhead of logs, locks, writes and "vertical reads" (group by), there is no way way to implement these design concepts in a traditional rdbms.

To split workloads with oracle, there is no easy solution. Read only standby database works unless you use mv or temp tables, dblinks unless you have blobs, and don't touch goldengate with a yard stick.

I didn't have the chance to play with 12c/rac yet, but my guess is that it comes with it's lot of undocumented features (looking at it's architecture chart did frighten me. As much as parallel execute explain plan).

Point is, it's doesn't work well out of the box, and even when everything is set up and monitored, it's still full of surprises. And most programmers people don't know jack about the sql world, they are lost when they have to open that box and look into it.

Alternatives don't seem mature (the full immutable/in_memory "newsql" pack) or require such paradigm change that migration (not of data, but minds) is impossible, despise the cost advantage that can soon reach millions, per year. And I'm sure traditional competitors have an even bigger sum of bodies in the closet.

/rant

Re: Multiverse needed

The planet we stand on is of the right size, with right elements, on the right spot, around a stable non binary star, in a quiet part of a galaxy that didn't collide with another for billions of years. Add the moon creation event, the migrating planet cleaning the solar system of much of it's asteroid and comets (after the brought water in), and so on.

This quite random, and supposedly rare, combination of conditions happens to be able to sustain life.

As well, according to multiverse/bubbleverse theories, we live in some instance that just happens, by chance, to be able to sustain matter and energy (and by this way life as we know it) for long enough time.

I think the analogy is quite apt, but it's hard to tell if it's right.

Paris, because it's how I feel in this theoretical universe.

A monopoly with like 40% market share, that's a new thing. a blinkopoly?

I did not dive into details yet, but if it follows ip usual hoops routing, ISP will be happy.

If a bunch of end users get their stream from a mini-broadcaster inside an ISP network, and not from the original source outside it, the isp will pay less for interconnection.

But of course, if the thing works so well that the total traffic explodes x10, we may feel it on our monthly invoice.

I wonder how the protocol works with "pause" and peer disconnections. Buffers management must be fun :) I have to read the real thing (damn customer stupidwall).

beer coz it's time!

Re: This is a Microsoft employee blogging phenomenon

But at least the Chinese army seems to be out of MS payroll for now.

and meanwhile, I mourn minimsft blog death.