Error: I'm afraid this is the first I've heard of a "trackback" flavoured Blosxom. Try dropping the "/+trackback" bit from the end of the URL.

Fri, 10 Feb 2006

A question one might ask at a technical interview:
Explain how high volume and a load-balanced environment can affect one’s coding approach.

My answer would be

  1. one might resort to caching of data (perhaps with Memcached, perhaps with Memoized).
  2. one might cache database handles (with Apache::DBI) or try to pool them
  3. one might create static content as much as possible and certainly be sure to have Apache serve all parts of a page which are static such as images.
  4. one might replicate the database
The actual questions:
  1. Given a text file with a full name on each line, print the 10 most common last names in the file… also do this in SQL.
  2. what does use strict do
  3. what variable controls inheritance in Perl
  4. a sub that modifies a hashref - trick question: they made a copy of the hashref in the modifying sub
  5. parse a URL
  6. simple INNER JOIN
  7. composite indexing question
  8. how to check if a slave is up
  9. hOW TO to see which processes heavy
  10. how to see disk activity
  11. How to see disk usage?
  12. how to check if apache is up?
  13. Design a couple of pages for a yearbook website
#