[hibernate-dev] SQLServer getLimitString() refactoring
Łukasz Antoniak
lukasz.antoniak at gmail.com
Thu Jun 7 16:34:00 EDT 2012
Hello Guenther,
The following commit in general describes my thoughts:
https://github.com/lukasz-antoniak/hibernate-core/commit/fa8427937f5751170714ec97ac059bee9efd8cff
It probably needs some more tuning. Feel free to modify and test. I'm not sure if adding "TOP(100)PERCENT" expression would not
harm performance too much.
Totally agree that we should simplify things. This is why I wanted to change the query structure, so that aliases do not get
stripped from the original query, DISTINCT is not simulated with GROUP BY etc.
Regards,
Lukasz
More information about the hibernate-dev
mailing list