In fact they tend to optimise per engine. If you look at NHibernate for example,... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		gouranga on May 1, 2012 \| parent \| context \| favorite \| on: Why Use Postgres In fact they tend to optimise per engine. If you look at NHibernate for example, if you do paging on SQL 2005+ it will use CTE yet on MySQL it will use LIMIT clauses underneath. Some enterprise products have a really crappy schema with an ORM thrown over the top - that's where the pain is.

josephcooney on May 2, 2012 [–]

Your definition of 'enterprise' might be different to mine. I'm thinking of SAP and PeopleSoft. And I think the crappy schema arises (sometimes) from not wanting to use any proprietary DDL features.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact