Far Beyond Code LLC

Bruce Kirkpatrick

Click here to see how google sees this page | Change Font Size: Smaller | Normal | Larger

Offering the best for less

Generate more leads and manage your online business with the best technology platform in the real estate industry. This online marketing solution for agents, teams and offices helps you increase your sales to new levels.

Look your best with our design services

Your web site is probably the first thing customers see before choosing to do business with you. Our designers understand how to communicate the image you want to represent.

"Search engine optimization" only means something when it actually works.

We don't sell you wonderful stories about your amazing online future. We know that most of our competitors just can't deliver. We'll make it easier for you through honesty, affordability and transparency.

Let us modernize the way you do business

Integrating disparate systems, enterprise search, custom intranets, ecommerce systems, automation, advanced reporting and analysis, online collaboration. You name it, we have done it.

Experience + Passion = MAXIMUM RESULTS

Since 2001, this labor of love has provided endless challenges. While many people struggle, Bruce eagerly solves complex computer problems. You need a passionate expert like Bruce on your team.

Mysql 5.6 goes GA today, but we will wait for MariaDB to update

Follow me:

Tue, Feb 05, 2013 at 10:20AM

MySQL 5.6.10 is the first generally available release of 5.6, meaning it's no longer beta software. The new release comes many new features like Innodb full-text search, NoSQL Innodb access via memcached api and more.

Innodb full-text search would still be slower performance then using sphinxse in MariaDB.

Oracle states that NoSQL Innodb access is up to 9 times faster for insert statements then using SQL statements.

https://blogs.oracle.com/MySQL/entry/nosql_memcached_api_for_mysql

While that may sound exciting, our web applications are mostly read-only. This page has charts showing that "get" operations are up to 2 times faster. That is a much smaller gain for what would require a lot of rewriting to implement and keep in mind that this is only for the most basic ID search queries. Queries that only grab data via the ID are exceptionally fast already often taking only 1 to 2 milliseconds, so twice as fast is such a small gain in that context. We are also using CFML for our applications, which has a lot more overhead compared to the direct Java or C API access that Oracle is using in their benchmarks. We'd need to test the performance on our system to see the actual benefits.

While I love to adopt the newest technology, we need to consider how Oracle has reduced some of the openness in MySQL. This is causing difficulty for other developers in the MySQL development community who depend on that openness. They now have to work harder to improve MySQL. This is unfortunate for the free open source community.

Follow the MariaDB discussion. To date, Oracle still has made no official statement about why they have implemented internal mysql-test suite.

http://blog.mariadb.org/disappearing-test-cases/

I hope that MariaDB is able to keep innovating and keep the most popular database more open and useful to small businesses like mine. I'm sure Oracle will also continue to innovate and we may see in the long term that we're forced to use MySQL again if the upstream community has someday been killed off.