Postgres Pro
Downloads
Home   >   mailing lists

DB access speeds, App(linux)<->PG(linux) vs App(linux) <->MSSql(Windows) - Mailing list pgsql-general

From Gauthier, Dave
Subject DB access speeds, App(linux)<->PG(linux) vs App(linux) <->MSSql(Windows)
Date
Msg-id 0AD01C53605506449BA127FB8B99E5E17BAA6856@FMSMSX119.amr.corp.intel.com
Whole thread Raw
Responses Re: DB access speeds, App(linux)<->PG(linux) vs App(linux) <->MSSql(Windows)  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: DB access speeds, App(linux)<->PG(linux) vs App(linux) <->MSSql(Windows)  (Andy Colson <andy@squeakycode.net>)
Re: DB access speeds, App(linux)<->PG(linux) vs App(linux) <->MSSql(Windows)  (Francisco Olarte <folarte@peoplecall.com>)
List pgsql-general
Tree view

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 ?

 

Thanks in Advance.

 

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Include.d and warnings
Next
From: Marc Mamin
Date:
Subject: Re: Counting the occurences of a substring within a very large text