Last active
May 17, 2019 01:37
-
-
Save daisukenishino2/c2da7b9fadf79c2ba7bcbfe01a73aea4 to your computer and use it in GitHub Desktop.
Open棟梁:動的パラメタライズド・クエリの性能測定に使用した、各種リソース情報と、その測定結果。
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0"?> | |
<ROOT> | |
SELECT * FROM SHIPPERS | |
<WHERE> | |
WHERE | |
<IF>SHIPPERID = @p1</IF> | |
<IF>hoge1 = @hoge1</IF> | |
・・・ | |
<IF>hoge1 = @hogeN</IF> → ここの「N」を、10, 20, 50, 100, 200, 500, 1000 タグと増やしていって性能を測定。 | |
</WHERE> | |
<PARAM> | |
p1, Int32, 1 | |
</PARAM> | |
</ROOT> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
自動生成Daoによる解決策
http://www.osscons.jp/jo1qzb1y1-537/