8.7

Table Of Contents
l All databases
l
User Rights:During normal operation, Read/Write to tables should be sufficient.
However, during the initial setup, the Create/Drop tables rights is necessary.
l Minimum 100MBof database size is required as a minimum, but the space
requirement depends on the implementation. The more active documents in the
database, the more space is used - note that this progression is rather linear.
l Regular database maintenance is required, such as database compacting, is
required by a system administrator.
l It is recommended to create an ITprocess that backs up the database regularly.
l The recommended ideal setup is a dedicated SQLServer PC, accessed by
PlanetPress Workflow through an ODBCconnection on the local network.
l Microsoft Access
l Database file (mdb)must be local to the PlanetPress Workflow computer. It cannot
be located on a network drive or another server.
l Total database size is limited to 4GBof data.
l Total size of a single table is 2GB.
l May be unstable in large implementations.
l MySQL
l Database can be in any location, but performance will depend on the speed of the
connection between PlanetPress and the MySQLserver.
l MySQL's performance has been slower than SQLServer and SQLServer Express
during our tests.
l By default, MySQLis configured not to allow any SQLrequest larger than 16 megs.
l In the event where 2 requests are made simultaneously on the same record,
MySQLwill queue one of the requests and execute it once the first one is done. In
extremely rare cases this may cause a timeout on very large requests.
l MSSQL(Microsoft SQLServer)
l All versions of the SQLServer are supported, including all Express versions.
l Database can be in any location, but performance will depend on the speed of the
connection between PlanetPress Production and the SQLserver.
l In the event where 2 requests are made simultaneously on the same record,
SQLServer will drop the most complex request. Resubmitting the PGCfor
processing should resolve this issue. This, however, should happen only rarely.
Page 150