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-4.0.4.0.0.tgz # tar xzf project-open-Update-4.0.4.0.0.tgz pg_dump.4.0.4.0.0.sql # killall -9 nsd; dropdb projop # createdb --owner=projop --encoding=utf8 projop # createlang plpgsql projop # time psql -f pg_dump.4.0.4.0.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.
Calle Aprestadora 19, 12o-2a
08902 Hospitalet de Llobregat (Barcelona)
Spain
Tel Europe: +34 609 953 751
Tel US: +1 415 200 2465
Mail: info@project-open.com