On Tue, 2006-05-09 at 17:16 -0400, Ricardo Stuven wrote:
> Please, see http://channel9.msdn.com/ShowPost.aspx?PostID=179064
>
> This is one of the few performance comparisons between PostgreSQL and
> MS SQL I have seen, and at first sight it seems too unfavorable to
> PgSQL... Maybe there is a bottleneck in the ODBC driver, Foxpro,
> VMWare or Windows, really I don't know, I'm not an expert, but I would
> not lightly believe in such results, especially for such queries that
> are so simple. However, a casual reader or someone wanting to choose
> between PostgreSQL and MS SQL could base his/her decision on that
> results.
All the queries tested are "Select *" issued with a single Exec, no
Fetch-es at all.
It's all down to how many rows are cached by the basic Exec call, in
anticipation of later Fetch-es.
You can always find a trick that one or other does better.
--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com
