if we're still using Date::Manip it's going to be hard to test speed accurately
is there a replacement module, possibly Date::Calc, or should we just use regex? Date::Manip is fine in places where its needed, like reports, where we let people input weird date ranges, but for circulation its not needed and is slow
strenghtening the database using InnoDB & foreign keys : what's done (Paul) and could be done. Requirements on mySQL (4.1 ? to have foreign keys & nested select)