Massachusetts Data Protection Law
Recently I came across this new Massachusetts state data protection security law that has been passed and wondering if anyone took an initiative to fix their data storage, especially if[...]
Monthly Archive: April 2010
Database · MySQL · Performance
INT and String data comparison, difference in performance because of quotes
In the last post choosing about the right type; there is a case about quoting the tuple values; that I forgot to mention which is pretty much a common mistake[...]
Database · MySQL · Performance
Choosing the right data type makes a big difference
Today evening one of my friend asked me in the IM to look into one of his production server where a query was taking ~11 seconds to run on 20[...]
Database · MySQL · Performance · Scalability
MySQL 5.5 – A Community Winner
Ever since MySQL 5.5 beta has been announced by Edward Screven, Oracle’s chief corporate architect; there is lot of positive buzz (here, here, …) about the performance and scalability improvements[...]
Database · Hardware · MySQL · Performance
RAID Controllers Cache Management – Missing Features
We all know how important hardware RAID controllers are in today’s data storage performance especially when dealing with large data sets. If we look at the trend from now to[...]
Database · Hardware · MySQL · NoSQL · Scalability
Data Store, Software and Hardware – What is best
Other day we had a small discussion about data stores and hardware; and which one drives the other when it comes to data storage solution, rather it is a hard[...]