langreiter.com plain, simple: comments-2006-02-17

LANGREITER.COM plain, simple

START

INDEX

Freitag, 17. Februar 2006

Darcs or Subversion?

2006-02-17-darvn

Michael Platzer looked at the database requests generated by Twoday; some very interesting results: A lot of time is spent in SELECT_IDS (could that be optimized? LIMITs?), also day and topic grouping is rather expensive.

Quite amazing how Helma makes it possible to run tens of thousands of dynamic sites on a fairly moderate configuration (AFAIK, still only two machines). The wonders of caching!

2006-02-17-twoSql

Michi's R-jockeying reminded me of my long-standing plan to write about some of the nuggets that digging through the retrievr log files netted. In the meantime, you might want to check out some of the features we've added over the past few weeks:

Sketches have URLs. Handy for showing off. Or not.

Search for similar images: In addition to drawing rough (*cough*) sketches, the artistically challenged (and everyone else, incl. you!) can upload images now.

One-click pivoting. Move the mouse cursor over an image, click the lens. Repeat. (An hour later ...)

Sketch rating. Raw and unfiltered (for now), so adjust your (in)decency filters beforehand.

Upcoming: The Bookmarklet. (Which is Great Fun, too.)

People who like retrievr are probably also going to like Sketch Swap and Mario Klingemann's Flickeur.

2006-02-17-retrology

digg: Quite, er, inspiring.

2006-02-17-clogg

gavin 6836 days AGO
Or Perforce!

chris 6835 days AGO
But ... is it written in Haskell?

michi 6834 days AGO
oh, it seems that i didn't bring across the point, that the SELECT_IDs actually were just the GROUPBY-statements. so all the distribution-stats are firlefanz, and the only relevant information can be detucted from my last list in that post.
and i also forgot to mention that i had to do some massive data-preprocessing with regexp-replacing to get rid of IDs and names, in order to be able to aggregate over the sql-statements.

chris 6834 days AGO
Ah yeah, now that you mention it ... should've looked more closely. Thanks for the clarification!

Please log in (you may want to register first) to post comments!