On 06/24/2015 06:44 AM, Gauthier, Dave wrote:
Hi: I'm trying to get a 10,000 ft understanding of the difference in DB
access speeds for two different scenarios...
Scenario 1: Apps are on linux. PG DB is on linux (different server
than apps)
Scenario 2: Apps are on linux. MSSql DB is on Windows (obviously a
different server)
The apps are typically perl scripts using Perl DBI.
I'm thinking that since perl has a DBD driver for PG, that would be
faster than going through ODBC to get to the MsSQL DB, but I'm not sure
about that.
Any insights/guesses ?
Not without more information.
1) The same schema, data on both DB servers?
2) Are they the same apps?
3) What are the apps doing?
Thanks in Advance.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
