Slowness on Accession List All

We've installed Archivists Toolkit on an Oracle database with about 6000 accessions and similar numbers of names, and subjects.

When we do a list all at of any of these it takes several minutes. When we do one for accessions it can take 10 minutes.

When I install your test bed on my computer each of these tasks is completed in seconds.

Our Oracle staff can see no activity on the database during this period, so we are stumped as to what is causing this.

Can anyone suggest a solution?

Thank you

Re: Slowness on Accession List All

Hi, Rich,

The slow performance of Oracle is due to Hibernate and the Oracle database driver. A search for "slow performance hibernate oracle" bring up numerous post where users have seen similar performance issues; unfortunately, none of these seems to provide a quick easy fix.