3 ms·
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 i
by jzawodn 13y ago
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.
- tudorconstantin 13y agoYeah, 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