ksql转成sql时limit信息丢失了

Masion

使用的mysql数据库
使用的bizData加载数据
控制台打印出来的的ksql是：
2017-04-18 12:13:58 [SQL Time]sql 执行时间：6005ms, exec KSQL: SELECT RU_YSTradeSummery.*  FROM RU_YSTradeSummery RU_YSTradeSummery LIMIT 0, 20


sql语句是（这条sql语句执行时间非常长）：
--> sql:SELECT  RU_YSTradeSummery.fID AS RU_YSTradeSummery, RU_YSTradeSummery.F1PSNTIME AS f1PsnTime, RU_YSTradeSummery.FACCOUNT AS fAccount, RU_YSTradeSummery.FCHENGJIAOBIANHAO AS fChengJiaoBianHao, RU_YSTradeSummery.FCHENGJIAOJIAGE AS fChengJiaoJiaGe, RU_YSTradeSummery.FCHENGJIAOLIUHAO AS fChengJiaoLiuHao, RU_YSTradeSummery.FCHENGJIAOTIME AS fChengJiaoTime, RU_YSTradeSummery.FCOSTCURRENCY AS fCostCurrency, RU_YSTradeSummery.FCOUNTSUM AS fCountSum, RU_YSTradeSummery.FCURRENCYTYPE AS fCurrencyType, RU_YSTradeSummery.FCUSTOMERCOST AS fCustomerCost, RU_YSTradeSummery.FHEYUEBIANHAO AS fHeYueBianHao, RU_YSTradeSummery.FJIESUANBIANHAO AS fJieSuanBianHao, RU_YSTradeSummery.FJIESUANRIQI AS fJieSuanRiQi, RU_YSTradeSummery.FKAIPING AS fKaiPing, RU_YSTradeSummery.FLASTCOST AS fLastCost, RU_YSTradeSummery.FLIUSHUIHAO AS fLiuShuiHao, RU_YSTradeSummery.FMAIMAI AS fMaiMai, RU_YSTradeSummery.FMARKET AS fMarket, RU_YSTradeSummery.FNETCOST AS fNetCost, RU_YSTradeSummery.FPRODUCT AS fProduct, RU_YSTradeSummery.FPRODUCTTYPE AS fProductType, RU_YSTradeSummery.FRIGHTMONEY AS fRightMoney, RU_YSTradeSummery.FSHOUGONGSHOUXUFEIBIAOZHI AS fSHouGongShouXuFeiBiaoZhi, RU_YSTradeSummery.FSETTLEGROUP AS fSettleGroup, RU_YSTradeSummery.FSHANGSHOUBIANHAO AS fShangShouBianHao, RU_YSTradeSummery.FSHANGSHOUCHENGJIAOLIUHAO AS fShangShouChengJiaoLiuHao, RU_YSTradeSummery.FSHANGSHOUCHENGJIAOTIME AS fShangShouchengJiaoTime, RU_YSTradeSummery.FTRADEMONEY AS fTradeMoney, RU_YSTradeSummery.FWEITUOHEYUEBIANHAO AS fWeiTuoHeYueBianHao, RU_YSTradeSummery.FWEITUOLAIYUAN AS fWeiTuoLaiYuan, RU_YSTradeSummery.FWEITUOLEIXING AS fWeiTuoLeiXing, RU_YSTradeSummery.FWEITUOPINGZHONGBIANHAO AS fWeiTuoPingZhongBianHao, RU_YSTradeSummery.FXITONGHAO AS fXiTongHao, RU_YSTradeSummery.VERSION AS version FROM RU_YSTradeSummery RU_YSTradeSummery
--> binds:[]


查询时间超级长，后来在这条sql语句后面加上 limit 0，20 后，执行只需要几十毫秒
我的问题是在mysql数据库链接中，ksql转sql语句后，为什么把limit搞丢了？？？？？？害得mysql去把所有的数据都查出来耗费不必要的时间

wgs7909

虽然是你在控制台里没有看到limit，但不代表真正执行的时候没有加limit。
你试着在前台的data组件上指定查询关系试试。之前我碰到了这种问题， 就是这么解决的。
前台需要什么，就查询什么，不要把所有的列都查询出来。
当时有个数据库专家跟我说，查询与行数有关系与列数没有关系。我当时信他的。结果证，与列数有很大关系 。
不有指定列数之前，执行需要30秒。指定后1秒不到。

Masion

wgs7909 发表于 2017-4-18 12:36
虽然是你在控制台里没有看到limit，但不代表真正执行的时候没有加limit。
你试着在前台的data组件上指定查 ...

你说的是另外一个问题

jishuang

http://docs.wex5.com/bex5-deploy-question-list-10027/

Masion

jishuang 发表于 2017-4-18 14:06
http://docs.wex5.com/bex5-deploy-question-list-10027/

楼上正解
结贴