You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Skip <sk...@thedevers.org> on 2013/07/04 01:57:06 UTC
locaopostnew vs localpostgres
Did some testing on these and have come to the following conclusions:
1. Postnew works with both old and new installations. Did significant beta
testing and discovered no issues. Exported all entities from
localpostgres to xml files and then imported them into localpostnew
installation. Works a charm.
2. Inspite of the comment in fieldtypepostnew.xml, localpostgres is
significantly faster than localpostnew. The comment says "Tip: there is no
performance differences between these three types...". That was not my
finding. In multiple test run (all reads), localpostres was in excess of
15% faster, and that is overall, not just the postgres part. Given that
most of the time is spent in ofbiz code, this is very significant. This was
using exactly the same data imported from the above mentioned xml files.
Hope this helps someone else considering this. I am going back to
localpostgres.
Skip
RE: locaopostnew vs localpostgres
Posted by Skip <sk...@thedevers.org>.
One additional note, it may be that postgres does indeed handle these the
same and the difference is in the Ofbiz code. In any event, there is a
significant difference.
Skip
-----Original Message-----
From: Skip [mailto:skip@thedevers.org]
Sent: Wednesday, July 03, 2013 4:57 PM
To: OfbizUser
Subject: locaopostnew vs localpostgres
Did some testing on these and have come to the following conclusions:
1. Postnew works with both old and new installations. Did significant beta
testing and discovered no issues. Exported all entities from
localpostgres to xml files and then imported them into localpostnew
installation. Works a charm.
2. Inspite of the comment in fieldtypepostnew.xml, localpostgres is
significantly faster than localpostnew. The comment says "Tip: there is no
performance differences between these three types...". That was not my
finding. In multiple test run (all reads), localpostres was in excess of
15% faster, and that is overall, not just the postgres part. Given that
most of the time is spent in ofbiz code, this is very significant. This was
using exactly the same data imported from the above mentioned xml files.
Hope this helps someone else considering this. I am going back to
localpostgres.
Skip