8.8

Table Of Contents
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.
l When configuring the ODBCconnection, your must use the Microsoft version of the
driver, and not the Native SQLversion of the driver. This is due to a technical
limitation of the native driver that interferes with the PlanetPress Suite database
requests.
Specifically for PlanetPress Capture, these considerations mean the following:
l In Microsoft Access, the total size of stored document cannot be larger than 2GB and
this database will be very unstable in implementation with more than a few thousand
pattern sequences being used simultaneously. It is only suggested for small
implementation with less than 10 pens, or for demos.
l In MySQL, the 16 megs packet size limit can be an issue if the PDFs created by Capture
are larger than this size; An error saying "MySQLServer has gone away" would appear in
this case. This can be fixed by configuring the max_allowed_packet setting in the
MySQLConfiguration(Reference).
l Also in MySQL, if a timeout occurs on simultaneous record access, resubmitting the
PGCfor processing should resolve the issue.
Page 151