Re: Perl/DBI vs Native

Поиск
Список
Период
Сортировка
От Valentin Bogdanov
Тема Re: Perl/DBI vs Native
Дата
Msg-id 698916.49812.qm@web25803.mail.ukl.yahoo.com
обсуждение исходный текст
Ответ на Re: Perl/DBI vs Native  ("Greg Sabino Mullane" <greg@turnstep.com>)
Ответы Re: Perl/DBI vs Native  ("Greg Sabino Mullane" <greg@turnstep.com>)
Список pgsql-performance
Thanks to everyone who replied. There were some really good points.

However, I found what is causing the difference. The perl program was connecting to the database via a TCP socket while
theC version was using Unix socket. I changed the connect in my perl script, so that it now uses Unix sockets as well.
Runthe tests again and got identical results for both programs. 

In case someone is wondering, the way to force DBI to use unix sockets is by not specifying a host and port in the
connectcall. 


Cheers,

Val


      __________________________________________________________
Not happy with your email address?.
Get the one you really want - millions of new email addresses available now at Yahoo!
http://uk.docs.yahoo.com/ymail/new.html

В списке pgsql-performance по дате отправления:

Предыдущее
От: Łukasz Filut
Дата:
Сообщение: Re: Less rows -> better performance?
Следующее
От: "samantha mahindrakar"
Дата:
Сообщение: Performance of jobs