Author Archives: fisharebest

MySQL Configuration and Performance

Posted on 5 August 2010 by fisharebest

MySQL has a large number of configuration options. Adjusting these can make an enormous difference to the performance of your database. Unfortunately, there is no single “best” set of settings. The optimal configuration depends on the version of MySQL, the … Continue reading →

Posted in Uncategorized | Tagged | Comments Off on MySQL Configuration and Performance

MySQL Cursor Loops – the easy way

Posted on 26 July 2010 by fisharebest

If you want to use a cursor, you are going to need a loop. All the examples on the MySQL website are a bit convoluted, have unnecessary flags and checks. This is a better way to do it:

Posted in Uncategorized | Tagged | Comments Off on MySQL Cursor Loops – the easy way

Genesis – In the beginning was GEDCOM…

Posted on 20 July 2010 by fisharebest

If you are familiar with genealogy, then you will almost certainly have come across GEDCOM file “formats”. I put the word in quotation marks because not only are there many versions of the format, every vendor has customised it to … Continue reading →

Posted in Uncategorized | Tagged | 2 Comments