2022.2

Table Of Contents
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 con-
nection between PlanetPress and the MySQL server.
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, MySQL will
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 SQL Server are supported, including all Express versions.
l
Database can be in any location, but performance will depend on the speed of the con-
nection between PlanetPress Production and the SQL server.
l
In the event where 2 requests are made simultaneously on the same record, SQL Server
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 SQL version of the driver. This is due to a technical limitation of the nat-
ive 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 data-
base 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 lar-
ger 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 MySQL Configuration
(Reference).
l
Also in MySQL, if a timeout occurs on simultaneous record access, resubmitting the PGC for pro-
cessing should resolve the issue.
Page 252