DB access speeds, App(linux)<->PG(linux) vs App(linux) <->MSSql(Windows)

Поиск
Список
Период
Сортировка
От Gauthier, Dave
Тема DB access speeds, App(linux)<->PG(linux) vs App(linux) <->MSSql(Windows)
Дата
Msg-id 0AD01C53605506449BA127FB8B99E5E17BAA6856@FMSMSX119.amr.corp.intel.com
обсуждение исходный текст
Ответы 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>)
Список pgsql-general
Дерево обсуждения

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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Include.d and warnings
Следующее
От: Marc Mamin
Дата:
Сообщение: Re: Counting the occurences of a substring within a very large text