Re: Comparative performance

Поиск
Список
Период
Сортировка
От PFC
Тема Re: Comparative performance
Дата
Msg-id op.sxvguropth1vuj@localhost
обсуждение исходный текст
Ответ на Re: Comparative performance  (Joe <svn@freedomcircle.net>)
Ответы Re: Comparative performance  (Joe <svn@freedomcircle.net>)
Re: Comparative performance  (Joe <svn@freedomcircle.net>)
Список pgsql-performance
>   Total runtime: 16.000 ms

    Even though this query isn't that optimized, it's still only 16
milliseconds.
    Why does it take this long for PHP to get the results ?

    Can you try pg_query'ing this exact same query, FROM PHP, and timing it
with getmicrotime() ?

    You can even do an EXPLAIN ANALYZE from pg_query and display the results
in your webpage, to check how long the query takes on the server.

    You can also try it on a Linux box.

    This smells like a TCP communication problem.

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

Предыдущее
От: PFC
Дата:
Сообщение: Re: Comparative performance
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: [HACKERS] A Better External Sort?