Tag Archives: mysql

Exodus – Leaving GEDCOM behind…

Posted on 28 May 2011 by fisharebest

In an earlier article, I discussed ideas for a relational database to replace GEDCOM for storing genealogical data. Since writing it, I have put my words into action, and migrated all my genealogy research into this database. This has revealed … Continue reading →

Posted in Uncategorized | Tagged , | 4 Comments

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