find_in_set是否效率更高哦

lilinew 2010-06-01 05:23:37

环境：mysql +java +linux +tomcat
SELECT from a, b where a.m=b.n and t.Id in (22833794,186608752,186608932,186610076,186600607,186576340,186576338,186610806,186610424,186586705,22833794,150555535,150634343,153999301,155064688,157079155,164912103,164912112,166890203,166891971,169111429,173809176,174693027,174693028,174693030,174693031,174693032,174693034,174693203,174693204,174693205,174693206,174693208,174693209,174693210,174695474,174695484,174695577,174697484,174697555,174697563,174713791,174713792,174857662,174863189,174870783,174886511,174886513,174888925,174888961,174889520,174889521,174923839,175577286,175577479,175581395,175581397,185127711,186471622,186488188,186488189,186488193,186489181,186509117,186516605,186517992,186517995,186542477,186559937,186568533,186576338,186576340,186586703,186586705,186586910,186586911,186600503,186600605,186600606,186600607,186602605,186602607,186604549,186608077,186608663,186608732,186608736,186608752,186608761,186608932,186610076,186610253,186610277,186610287,186610424,186610806,186610981,186611312,186611314,186611317,186611318,186611327,186611328,186611532);

这个sql 不是很好看

我准备换find_in_set(id, strlist)

那个(22833794,186608752,186608932,186610076,186600607,186576340,186576338,186610806,186610424,186586705,22833794,150555535,150634343,153999301,155064688,157079155,164912103,164912112,166890203,166891971,169111429,173809176,174693027,174693028,174693030,174693031,174693032,174693034,174693203,174693204,174693205,174693206,174693208,174693209,174693210,174695474,174695484,174695577,174697484,174697555,174697563,174713791,174713792,174857662,174863189,174870783,174886511,174886513,174888925,174888961,174889520,174889521,174923839,175577286,175577479,175581395,175581397,185127711,186471622,186488188,186488189,186488193,186489181,186509117,186516605,186517992,186517995,186542477,186559937,186568533,186576338,186576340,186586703,186586705,186586910,186586911,186600503,186600605,186600606,186600607,186602605,186602607,186604549,186608077,186608663,186608732,186608736,186608752,186608761,186608932,186610076,186610253,186610277,186610287,186610424,186610806,186610981,186611312,186611314,186611317,186611318,186611327,186611328,186611532);
全部放到 strlist。

现在不知掉哪个效率更高？？（执行时间看不出来，网上找半天，有人说这好有人说那好都不确定）

...全文