faster refresh

HI, i developed a quite complex DB that should manages thousands of records and at list 60 different tables.

I should add many other tables but the speed of refresh the is at now very low in some of the most complex tables.

I thought about separate the topics of the db in separate dbs.

there is a way to link separate db and how?

many thanks.

Max