Database Blog
The importance of documentation, organization, and cross-training
A recent experience on a large database development project illustrates three very important principals to follow when developing a large computer system; keeping code well organized, keeping code well documented, and ensuring that more than one person is familiar...
Oracle Performance Tuning — Log Sync Waits
I recently worked with a client to resolve a significant performance issue related to painfully slow queries in an Oracle database. One of the queries that they wished to execute was taking over five hours to run. This is an Oracle 10g database running on a Solaris...
Five reasons why I avoid database query hints
I know that some will disagree with me on this but I have never been a fan of query hints.
Most database vendors give you the ability to override the query optimizer with hints that you specify in a query. Each query can be executed in a variety of ways by the…
Storing documents in a MongoDB database instead of the file system
We are currently working on an application that uses a mysql database. The application produces a large number of csv files that must be kept around for a few weeks, and then removed after being used in various ways by the users of the system. We need to keep track of...