News for hackers. Stuff that matters.
Re:The Fall Of Perl, The Web's Most Promising Language by jzawodn on Monday February 24, 2014 @12:12AM (#7289208)
Authorization via sphinx? Interesting!

In any case, we use Perl heavily at Craigslist and are helping to sponsor the continued work on Perl6. I don't think it's nearly as bad as people seem to think. But time will tell, of course.

Re:The Fall Of Perl, The Web's Most Promising Language by tudorconstantin on Wednesday February 26, 2014 @10:39AM (#7305554)
Yeah, basically there are 100k+ users in DB and 800k+ documents. Each document is filed under one or more geographies and one or more industries. Each user is entitled to access one or more geographies with one or more services. The SQL queries, besides that they have very complex where clauses, are very slow.

We use sphinx by indexing those documents, and attaching the geographies and industries as tags to each document. Whenever a user logs in, it takes only a few hundreds of miliseconds to get the latest documents he needs to see