I am a new customer and am about to install Pres Connect for the first time.
Is there any documentation regarding the database used by Pres Connect (MySQL vs. MS SQL Server).
For example, does one run “smoother” than the other as far as speed?
Would I loose any functionality by choosing MS SQL?
Do both databases handle encryption?
Any tips and/or feedback would be greatly appreciated.
Thanks,
Mario
As far as pure functionality is concerned, Connect considers MySQL and MS-SQL to be equivalent and will therefore not offer more or less functionality using either engine.
So both will work, but it should be noted that Connect was built to specifically take advantage of some MySQL features. For instance, internal SQL statements have been optimised for use with MySQL and while they will still work fine with MS SQL, some of them may not provide the same kind of performance.
For those reasons, I would recommend using MySQL.
That makes sense.
Thanks very much for the quick reply!