Month: September 2018

Speeding up wildcard searches

I ran into this article today, and I had to share. Storing the string in reverse format (and indexing it) allows you to find partial matches, quicker. It’s a good solution: Faster SQL Server Wildcard Search We could use an alternative method to get the same result more efficiently with an index seek. See the…

GitHub MySQL High Availability

Reading about the mysql environment at github, I was surprised to hear that they have 15tb of data in mysql. I was more amazed to read that Github has 15 different clusters for MySQL. I wonder why they have so many? I used to work on an Operational Data Store database that had a daily…

Financial Accounting with Odoo

I was surprised to look at Googke News and see an article that showed that Odoo is wildly popular. The book ‘Financial Accounting with Odoo’ actually has climbed to be the #1 New Release on Amazon. I always knew that Odoo is an amazing product. I think that more companies should consider Odoo. Today I…

Quick Quiz About SQL Server Indexing

Wow this survey has some interesting questions. I was happy that I got an 80% score on my first try. I think that in general, indexes are the first and the most important thing to implement correctly if you want good performance. Of course, most of the people that I’ve worked with are actually terrified…

BrytlytDB 2.1 & a 5-node IBM Minsky Cluster

So this looks interesting. I guess that BrytlytDB is a PostgreSql-compatible database that runs on Gpu (video cards). I wonder what his benchmarks would look like if he was using the SSD drives instead of the single 7200 room drives. http://tech.marksblogg.com/billion-nyc-taxi-rides-brytlytdb-ibm-minsky.html