HN user

Lozzer

65 karma
Posts2
Comments44
View on HN

Metadata operations on partitions can be very fast. One simple example is date based housekeeping. Deleting a month of data will be quite intensive on most databases, whereby dropping a partition from the table is effectively instant.

Partion switching is also fast. Say you have a summary table that is rolled up by month, but you want to recalculate the summaries every so often. You can build a month into a new table and then switch the new table for a partition in the summary table.

John Nash Has Died 11 years ago

Didn't wear a seatbelt and headbutted the person in front, snapping their neck. Sucks to be them, I guess. But at least you stuck it to the man.

Funnily enough if you buy Tesco's electrical goods online and pick up at store you don't get a paper receipt. The security guard (through lack of training) wasn't keen on letting me out without one.

I had a go at something similar for the Facebook version a couple of years ago. My main goal was to stop playing the game, but it was also an excuse to try Clojure. At the time it absolutely thrashed my best scores, though I'm sure it won't work with the updates the developers have made since then.

I think it was the first thing I wrote that drove home the power of having a REPL for exploratory programming:

https://gist.github.com/490689

We have a legacy database we support that creates a new dynamic stored procedure (with the same body) every time it performs a particular operation. How you can have enough knowledge to do this, but not to use a single procedure is beyond me.

War on Urchin 15 years ago

No, because you would reasonably requests with different parameters to return different pages.

I've used an offset mortgage to keep a large cash reserve, but to pay off real estate if I'm not using it.

That's for personal stuff, not sure if there are corporate options.

I estimate by considering an optimistic, pessimistic and normal value for each task. I then have a spreadsheet that does a modicum of statistical analysis to give you times against probability that the task will be finished.

Some of the benefits I find are:

1. Getting into the pessimistic mindset helps produce better estimates

2. Tasks with a large spread are things you aren't really clear about, and are an obvious target to be attempted first

3. Giving a range of values to the person asking for the estimate seems to help them remember it is an estimate.