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
Rich
- Login to post comments
Application Bugs
Bug reports can
be transmitted using the bug report function in the application. Otherwise they should be sent to the AT project at info@archiviststoolkit.org
Other comments or questions should also be sent to info@archiviststoolkit.org
Copyright 2006-2009
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.
Annie