brylie

(...) Hello and welcome to this open source live code hangout. Today we're going to continue a draft pull request to reduce the amount of search page usage.(...) Trying to basically optimize the app and our search page is one of the least performant pages. We don't have a lot of control over that it's just a complicated query that needs to span multiple tables.(...) So rather than try to optimize it which I don't know where to begin I would just rather we not use it for certain things.(...) Part of this issue is that we're getting hit by a lot of crawlers and bots and I don't know what the purpose of them is. Some of them are from Microsoft and Google I think. They're really causing an excessive amount of traffic on our site and queries against the database as well as expenses for example our analytics. We have this open source private(...) preserving analytics service but we're paying for their commercial hosting and we've exceeded our yearly budget of 600,000 hits in less than a month basically or maybe abo