I wouldn't expect much (if any) performance gain from moving the archived tables to a separate database. If the archived data is not being accessed, then it's not generating I/O load, nor is it taking up memory (cache), and so long as it's archived to separate tables then it's not effecting the size of the indexes on the primary tables.