I created an index on one field, which the database was dumped for backup. The operation took 5 hours, which is odd for the amount of data (156 million rows) Queries not working as it should I ran the new code using the new index, and it seems very slow—doing a select on the index…

If you’re following my blog posts, you read that I had to develop my own database because MySQL insert speed was deteriorating over the 50GB mark. That’s why I tried to optimize for faster insert rate. The application was inserting at a rate of 50,000 concurrent inserts per second, but it grew worse,  the speed…

If you know a thing or two about databases, the mere thought of writing a database should set off alarm bells, and if you had asked me 3 years ago I would have probably told you to drop it – why write a database? With so many good free open source databases on the market,…