This benchmark can provide you with a relvant measure of your database performance, which usually represents the bottleneck of a ]po[ installation.
The benchmark will destroy the database of your "projop" ]po[ instance, so please execute with care. You probably want to perform a backup of your database in ]po[ Admin -> Backup -> New Backup.
In order to execute the benchmark, please open up a Linux shell and type:
# su - projop # wget http://sourceforge.net/projects/project-open/files/project-open/V4.0/project-open-Update-188.8.131.52.0.tgz # tar xzf project-open-Update-184.108.40.206.0.tgz pg_dump.220.127.116.11.0.sql # killall -9 nsd; dropdb projop # createdb --owner=projop --encoding=utf8 projop # createlang plpgsql projop # time psql -f pg_dump.18.104.22.168.0.sql > import.log 2>&1
The last line should take between 5 and 300 seconds, depending on the speed of your system.
The following values are rough estimates:
Please [contact|contact us] for more information.