Proposed table structure changes for table 'authors'

[kristiank]

An index could be added so that author_db.php->getByExactName() query would run much quicker.

ALTER TABLE .author DROP INDEX surname ,
ADD INDEX exactname ( surname ( 10 ) , firstname ( 10 ) , von ( 5 ) , jr ( 5 ) )

This Issue is part of an attempt to optimize importing into a big Aigaion database (currently 10,000+ authors, 80,000+ publications). Our installed Aigaion seems to crash or time-out when importing datasets with more than 300 publications.

[kristiank]

With the index added, the crash or time-out seems to occur after importing between 900 and 1000 entries.