2018.2

and cannot access the 64-bit data sources. In order to create an ODBC connection visible
by PReS, you will need to access the 32-bit version of the ODBC manager, available in
C:\Windows\SysWOW64\odbcad32.exe .
The following considerations should be kept in mind while working with ODBC Databases in
PReS Suite.
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 PReS
Workflow through an ODBC connection on the local network.
l
Microsoft Access
l Database file (mdb) must be local to the PReS 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 PReS 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.
Page 585