Performance MSSql vs PostgreSql

Posted By: zzzzz | Apr 3rd, 2006 @ 5:33 PM
page 2 of 2
Comments: 27 | Views: 19615
#Apr 6th, 2006 @ 6:53 AM
blowdart
blowdart
Peek-a-boo
Sourcecode wrote:

What are your opinions of English Query? Gut feeling, or otherwise.

Thanks for the input.



I know someone who worked with it a lot with SQL 2k. They got very sucessful results. Like OLAP, it's all in the way it's configured, and they configured it well, and tuned it every few days during the initial roll out.

But I can't even see it for 2005
#Mar 27th, 2008 @ 12:36 AM
unix?
unix?
Have you used the MySQL default configuration? Please do not use the MySQL default configuration - because it is not very useful. You get different MySQL configuration template for small, medium and large setups. e.g. you should not use a large setup (needs more memory) on a linux vserver (virtual) with 512MB RAM. The nice thing with MySQL is that it supports different storage engines and the configuration is very flexible - you can set each buffer size in configuration. Of course you have to know what you are doing... But do not use the default configuration for performance tests. You have to check which storage engine you are using, etc... You can mix up storage engines in the same database too.
#Mar 27th, 2008 @ 12:38 AM
Sven Groot
Sven Groot
My name has 9 letters. Coincidence? I think not...
Please don't resurrect two year old threads.
page 2 of 2
Comments: 27 | Views: 19615
Microsoft Communities