and this is why we test our results

okay kids, remember that thing about when stuff is too good to be true? well, yeah, pretty much that means it's not.

so that whole "1 million" figure from last week? turns out i'm a moron that can't type, and one of my conditionals effectively read: "if (x<MIN||x<MAX) return false" --- like i said, i'm a moron.

anyway, i just ran the ionian batch again with the corrected version, and now i've got 411,003 records, which probably puts us back up in the just shy of three million range (as an initial guesstimate) for all magnificent seven of them. which, as i said before (when i though it was 3.5 million) still isn't bad... we'll just have to see what we can do with it next.

UPDATE:

here are the latest results.


mysql> select count(cantus.id) as count,mode.name as mode from cantus, mode where cantus.mode = mode.degree group by mode;
+--------+------------+
| count | mode |
+--------+------------+
| 393230 | Aeolian |
| 394386 | Dorian |
| 411003 | Ionian |
| 309340 | Locrian |
| 289798 | Lydian |
| 383144 | Mixolydian |
| 414909 | Phrygian |
+--------+------------+
7 rows in set (18.06 sec)

mysql> select count(cantus.id) as total from cantus;
+---------+
| total |
+---------+
| 2595810 |
+---------+
1 row in set (0.01 sec)