Glad You're Ready. Let's Get Started!

Let us know how we can contact you.

Thank you!

We'll respond shortly.

Standup 09/03/2008

Interesting Things

  • MySql only allows indexes on 64 columns per table. This is a hard limit, set in the header file, and therefore can’t even be changed at compile time without editing that file first. It was suggested that anyone who wants more than 64 indexes should not be using a database for searches anyway — use something like Solr instead.

  1. Also, considering that MySQL will only ever use one index per table in a query, if you hit this limit, you’re probably doing something wrong. (I wrote up this and a few other lesser-known tips here.)

  2. Joe Moore says:

    @Brad — Thank you for the tips!

Post a Comment

Your Information (Name required. Email address will not be displayed with comment.)

* Copy This Password *

* Type Or Paste Password Here *