ansaurus

Question

sql server vs postgres in .net SqlConnection vs NpgsqlConnection

Answer 1

+1 A:

A quick guess is Npgsql is not as optimized as the Microsoft SQL Server .net connection library. You pretty much proved that when the SQL Server query was 30% faster when invoked via .net. Did you run the test a few times one after another for both databases? Just make sure SQL Server wasn't caching data making it look blazing fast compared to PostgreSQL going out to disk for the same data.

StarShip3000 2010-09-28 17:02:02

@StarShip3000 yes I know about this, 2nd time they are both faster (postgres caches also, I guess), but sql server is still 30% faster, doesn't matter 1st time or 2nd, although there is a big difference between 1st and 2nd time you execute the same query

Omu 2010-09-28 19:05:46

@Omu Plus you have to keep in mind all the variables at work here. Are both databases on the same hardware? With the same load? Are both configured to be exactly the same? Lot's of possible variables at work here. But it appears that you are showing it probably has to do with the .net drivers. With the SQL Server being more per formant at least under your select * from foo test, which is a really unrealistic query to be running for real world test results. Normally never select *, and it's rare you would select all rows from a table unless you are caching a look up tables values.

StarShip3000 2010-09-29 17:17:41

@StarShip3000 servers are exactly the same, anyway that doesn't really matters, because posrgre is much faster than sql server but not via NpgSql,.net

Omu 2010-09-29 19:11:11

@Omu have you tried the Devart driver for Postgres? I wouldn't be surprised if it was faster than Npgsql.

Cory Grimster 2010-10-01 13:57:58

@Cory Grimster as a matter of fact I did tried it, and it almost 2 times slower, but it does support TransactionScope(), so it is very possible that this is what I'm going to use

Omu 2010-10-01 14:02:00

ansaurus

tags:

views:

answers:

sql server vs postgres in .net SqlConnection vs NpgsqlConnection

related questions