MySQL Configuration and Performance

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 server resources, other server processes, etc. It is also dependent on the server role; development, testing or live operation. Continue reading

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

MySQL Cursor Loops – the easy way

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: Continue reading

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

Genesis – In the beginning was GEDCOM…

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 some extent, partly to ensure lock-in, partly because it contains errors and incompatibilities, and partly because the limitations of the format forces the decision upon them. Continue reading

Posted in Uncategorized | Tagged | 2 Comments