| Andrew Cooke | Contents | Latest | RSS | Twitter | Previous | Next

C[omp]ute

Welcome to my blog, which was once a mailing list of the same name and is still generated by mail. Please reply via the "comment" links.

Always interested in offers/projects/new ideas. Eclectic experience in fields like: numerical computing; Python web; Java enterprise; functional languages; GPGPU; SQL databases; etc. Based in Santiago, Chile; telecommute worldwide. CV; email.

Personal Projects

Lepl parser for Python.

Colorless Green.

Photography around Santiago.

SVG experiment.

Professional Portfolio

Calibration of seismometers.

Data access via web services.

Cache rewrite.

Extending OpenSSH.

C-ORM: docs, API.

Last 100 entries

Have to add...; Culturally Liberal and Nothing More; Weird Finite / Infinite Result; Your diamond is a beaten up mess; Maths Books; Good Bike Route from Providencia / Las Condes to Panul\; Iain Pears (Author of Complex Plots); Plum Jam; Excellent; More Recently; For a moment I forgot StackOverflow sucked; A Few Weeks On...; Chilean Book Recommendations; How To Write Shared Libraries; Jenny Erpenbeck (Author); Dijkstra, Coins, Tables; Python libraries error on OpenSuse; Deserving Trump; And Smugness; McCloskey Economics Trilogy; cmocka - Mocks for C; Concept Creep (Americans); Futhark - OpenCL Language; Moved / Gone; Fan and USB issues; Burgers in Santiago; The Origin of Icosahedral Symmetry in Viruses; autoenum on PyPI; Jars Explains; Tomato Chutney v3; REST; US Elections and Gender: 24 Point Swing; PPPoE on OpenSuse Leap 42.1; SuperMicro X10SDV-TLN4F/F with Opensuse Leap 42.1; Big Data AI Could Be Very Bad Indeed....; Cornering; Postcapitalism (Paul Mason); Black Science Fiction; Git is not a CDN; Mining of Massive Data Sets; Rachel Kaadzi Ghansah; How great republics meet their end; Raspberry, Strawberry and Banana Jam; Interesting Dead Areas of Math; Later Taste; For Sale; Death By Bean; It's Good!; Tomato Chutney v2; Time ATAC MX 2 Pedals - First Impressions; Online Chilean Crafts; Intellectual Variety; Taste + Texture; Time Invariance and Gauge Symmetry; Jodorowsky; Tomato Chutney; Analysis of Support for Trump; Indian SF; TP-Link TL-WR841N DNS TCP Bug; TP-Link TL-WR841N as Wireless Bridge; Sending Email On Time; Maybe run a command; Sterile Neutrinos; Strawberry and Banana Jam; The Best Of All Possible Worlds; Kenzaburo Oe: The Changeling; Peach Jam; Taste Test; Strawberry and Raspberry Jam; flac to mp3 on OpenSuse 42.1; Also, Sebald; Kenzaburo Oe Interview; Otake (Kitani Minoru) move Black 121; Is free speech in British universities under threat?; I am actually good at computers; Was This Mansplaining?; WebFaction / LetsEncrypt / General Disappointment; Sensible Philosophy of Science; George Ellis; Misplaced Intuition and Online Communities; More Reading About Japan; Visibilty / Public Comments / Domestic Violence; Ferias de Santiago; More (Clearly Deliberate); Deleted Obit Post; And then a 50 yo male posts this...; We Have Both Kinds Of Contributors; Free Springer Books; Books on Religion; Books on Linguistics; Palestinan Electronica; Books In Anthropology; Taylor Expansions of Spacetime; Info on Juniper; Efficient Stream Processing; The Moral Character of Crypto; Hearing Aid Info; Small Success With Go!; Re: Quick message - This link is broken; Adding Reverb To The Echo Chamber; Sox Audio Tools

© 2006-2015 Andrew Cooke (site) / post authors (content).

Thinking About Databases, Efficiency and Technology

From: "andrew cooke" <andrew@...>

Date: Sat, 22 Nov 2008 17:20:53 -0300 (CLST)

The discussion at
http://ask.metafilter.com/82769/How-is-Facebook-doing-its-queries made me
think a little.

Some of the comments there seemed a bit confused about the concepts
involved.  The biggest confusion seemed to be between implementation and
logical function.

While my experience is limited to smaller projects, I have found that
managing data efficiently generally depends very much on the particular
circumstances at the time.  The best solution will involve trade-offs that
exploit particular details of the problem at hand.

That doesn't mean that there are not certain useful technologies.  You are
almost always going to use a database, for example.  But those
technologies are going to be complex, and to use the efficiently you will
need to first understand what you are going to do in logical terms, and
then how to do that within a particular tool.

So in the discussion I was reading the "right" answer is not going to be
"use technology X".  It is going to be "do X; it can be achieved with
technology Y in this way or with technology Z in this way".


It is worth thinking about whether there is a problem at all.  One
particularly odd answer in that discussion was raving about hibernate.  I
wonder if the poster had ever considered how a database is implemented,
looked at the obvious correspondence between foreign keys and Java
references, or understood that a database can also cache data in memory.

It seems fairly clear that there is only a problem, then, if there is too
much data to fit into memory.  And even then, it is not clear that
explicit caching is going to improve performance - a database also capable
of caching recent results internally.

Yet it's also obvious explicit caching (eg memcache) works - everyone uses
it.  Why?

There seem to be two answers to that.  First, it's simpler (and more
familiar to many programmers) than configuring a complex database
solution.  I imagine that in many cases you could have careful data
partitioning and denormalisation (incidentally, as far as I can tell, this
is "sharding" - see
http://highscalability.com/unorthodox-approach-database-design-coming-shard),
or master/slave databases doing the same job (although this is going to
depend on the database - there is probably a financial factor here).

Second, explicit caching lets you trade consistency for efficiency.  To
some extent you can get this with databases by ignoring transactions, but
I suspect an explicit cache lets you take the idea much further.

Is that it?

I need to read more at http://highscalability.com/

Andrew

Comment on this post