[Imc-tech] Re: [Imc-(tech|web)] Dada upgrade

[Daniel S. Lewart]

Clint,

> Ok, it's done.  I didn't end up having to do the database piecemeal,
> because I found a workaround to mysql's braindead index-updating
> algorithm.(*)

Excellent!!!

>   www.ucimc.org is /var/www/ucimc with database ucimc, version .98.1
>   old.ucimc.org is /var/www/old-ucimc with database ucimc-dada, version .94

> I have made no modifications to the site code, and I discourage it
> immensely, given my experience updating the site this time.  The
> newest code has a pretty sophisticated stylesheet structure, and if
> you can't do what you want with that, then you need to do diffs and
> submit them to dada's maintainer, IMHO.

Sounds perfectly reasonable.

> (*) The trick was to delete the non-primary indices on the articles
> table before letting the various update.php scripts do their UPDATE
> statements, and then recreate them afterwards.  Otherwise MYSQL
> updates EACH INDEX after EACH ROW.  Ugh.  And there is no way (in our
> version of mysql) to turn this off, AFAICT.  It's so bad that even
> "delete from X where Y" will be O(N^2).

Perhaps the update.php scripts should drop and add indexes?
Imsahp appears to have a mixture of MySQL 3.23.49-8.5 and 3.23.51-1woody.
I figure you would have liked the following MySQL 4.0.0 commands:
	ALTER TABLE ... DISABLE KEYS
	ALTER TABLE ... ENABLE KEYS
Should we ask Zach about installing mysql-nonfree 4.0.17?

Thanks!
Dan