The Lounge is rated PG. If you're about to post something you wouldn't want your
kid sister to read then don't post it. No flame wars, no abusive conduct, no programming
questions and please don't post ads.
I recently posted about some performance issues I was having with SQL. I did give up on SQL, though I created an in-memory filter using a cache created as a hashset of a few merged SQL tables. For all cases I've tested, it works in real-time. The hashset is updated every 8 hours (taking about 4 seconds each update) and only takes up about 20MB of RAM.