. .

YAPC::EU 2010 - The Renaissance of Perl



An optimization primer: DBIx::Perlish

An optimization primer: DBIx::Perlish

By Anton Berezin (‎Grrrr‎) from Copenhagen.pm
Date: Thursday, 5 August 2010 10:30
Duration: 50 minutes
Target audience: Advanced
Language: English
Tags: databases optimization optree parser

You can find more information on the speaker's site:

The DBIx::Perlish module allows one to use a domain-specific declarative
language with Perl syntax instead of SQL for making database queries.
This ability comes at a price, however - the parsing of Perl opcode
tree that the module performs takes a surprizingly large amount of time.

The talk delves into the implementation details of DBIx::Perlish and its
helper modules and then proceeds to discuss challenges involved in
making the module cache the generated SQL, together with the solutions
to those challenges.

While most of the advanced concepts used by the module will be briefly
introduced in the talk, it will help if the audience has at least some
level of familiarity with perl optrees.

Attended by: Nicholas Clark, Aaron Crane (‎arc‎), Lars Thegler (‎tagg‎), Salvador Fandiño (‎salva‎), Karl Rune Nilsen (‎krunen‎), Markus Pinkert (‎Bedivere‎), Henrik Andersen (‎HEM‎), Joel Bernstein (‎joel‎), James Mastros (‎theorbtwo‎), Steffen Schwigon (‎renormalist‎), Lars Dɪᴇᴄᴋᴏᴡ 迪拉斯 (‎daxim‎), Maciej Czekay (‎Bruno‎), Leon Timmermans (‎leont‎), Zefram .,

Our sponsors


  • Booking.Com
  • YAPC::Europe 2009
  • cPanel


  • Shadowcat
  • 123 people
  • Venda
  • Dada


  • YAPC::Europe Foundation
  • Smart Open Software
  • MySQL
  • Exonetric
  • pair Networks


  • GitHub
  • Italpro
  • Geoesse
  • $foo Perl Magazin
  • Lokku
  • Apress
  • No Starch Press
  • O'Reilly Media

Media Partners

  • Linux Magazine


  • Regione Toscana
  • Comune di Pisa