Based on the following results, we should go for the Remove NLS_SORT approach. Johnson and Felix should work together to create an example on how we can support UPPER in both Oracle and SQLServer in Java.
-----邮件原件-----发件人: Johnson Jiang 发送时间: Monday, 30 July, 2007 17:03收件人: Steve Chien; Tom Zhou; Thomas Lo; Alex Qiu; Oliver Zheng; Felix Tian主题: Performing test results(2)
三种模式下系统的性能，方案分别为
1. 现有模式
2. 转NUMBER模式
3. 去掉NLS_SORT模式
SQL ONE
SELECT * FROM (SELECT user0_.UserId AS UserId0_0_, userdefaul1_.UserId AS UserId5_1_, user0_.DelegateEndDate AS Delegate2_0_0_, user0_.DelegateStartDate AS Delegate3_0_0_, user0_.Description AS Descript4_0_0_, user0_.Address1 AS Address5_0_0_, user0_.Address2 AS Address6_0_0_, user0_.City AS City0_0_, user0_.State AS State0_0_, user0_.Country AS Country0_0_, user0_.Fax AS Fax0_0_, user0_.CellPhone AS CellPhone0_0_, user0_.Email AS Email0_0_, user0_.EmployeeId AS EmployeeId0_0_, user0_.FirstName AS FirstName0_0_, user0_.LANGUAGE AS Language0_0_, user0_.LastName AS LastName0_0_, user0_.UserType AS UserType0_0_, user0_.LicenseType AS License18_0_0_, user0_.LoginType AS LoginType0_0_, user0_.MiddleName AS MiddleName0_0_, user0_.Password AS Password0_0_, user0_.Phone AS Phone0_0_, user0_.Status AS Status0_0_, user0_.CreatorTS AS CreatorTS0_0_, user0_.CreatorId AS CreatorId0_0_, user0_.TS AS TS0_0_, user0_.zip AS zip0_0_, user0_.UserName AS UserName0_0_, user0_.Title AS Title0_0_, user0_.ResourceFlag AS Resourc30_0_0_, user0_.tsUserId AS tsUserId0_0_, user0_.DelegateUserId AS Delegat32_0_0_, (SELECT r.tbh FROM Resources r WHERE r.resId = -user0_.userId) AS formula0_0_, -user0_.userId AS formula1_0_, userdefaul1_.CoShowTooltips AS CoShowTo2_5_1_, userdefaul1_.DefaultCoFilterId AS DefaultC3_5_1_, userdefaul1_.CoProductId AS CoProduc4_5_1_, userdefaul1_.coProductVersionId AS coProduc5_5_1_, userdefaul1_.DefaultCoTemplateId AS DefaultC6_5_1_, userdefaul1_.DefaultCoViewId AS DefaultC7_5_1_, userdefaul1_.PmPlanId AS PmPlanId5_1_, userdefaul1_.PmFilterId AS PmFilterId5_1_, userdefaul1_.PmViewId AS PmViewId5_1_, userdefaul1_.PmOpenLevel AS PmOpenL11_5_1_, userdefaul1_.CostDisplayLevel AS CostDis12_5_1_, userdefaul1_.ShowEmptyCost AS ShowEmp13_5_1_, userdefaul1_.DynamicDashHome AS Dynamic14_5_1_, userdefaul1_.OnlineStatus AS OnlineS15_5_1_, userdefaul1_.SendEctypeEmail AS SendEct16_5_1_ 来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10662397/viewspace-957212/，如需转载，请注明出处，否则将追究法律责任。
下一篇： 没有了~
请登录后发表评论
登录
全部评论
<%=items[i].createtime%>
<%=items[i].content%> <%if(items[i].items.items.length) { %>
<%for(var j=0;j
<%}%> <%}%>
<%=items[i].items.items[j].createtime%>
回复
<%=items[i].items.items[j].username%> 回复 <%=items[i].items.items[j].tousername%>： <%=items[i].items.items[j].content%>
还有<%=items[i].items.total-5%>条评论
) data-count=1 data-flag=true>点击查看
<%}%>
北京盛拓优讯信息技术有限公司. 版权所有 京ICP备09055130号-4 北京市公安局海淀分局网监中心备案编号：11010802021510 广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员 |
转载于:http://blog.itpub.net/10662397/viewspace-957212/
扫一扫
3479
到【灌水乐园】发言
