HandlerSocket-Plugin-for-MySQL icon indicating copy to clipboard operation
HandlerSocket-Plugin-for-MySQL copied to clipboard
verified publisher icon DeNA

Support for IN query

Open yashh opened this issue 15 years ago • 3 comments

It would be awesome if HandlerSocket supports IN query. Most of the time an app fetches data for a list of primary keys. Is handlersocket going to support IN anytime soon?

yashh avatar Jan 01 '11 05:01 yashh

HandlerSocket supports request pipelining, which is an alternative to IN queries. I guess supporting dedicated IN queries will not make it much faster.

ahiguti avatar Jan 02 '11 00:01 ahiguti

Could I ask why MySQL IN queries outperform HandlerSocket when the number of keys in the IN construct exceeds ~25? This is what I have observed in my testing at least. I am using execute_multi. My lookups on handlersocket top out at 650000 rows read per second (when using 25 PK's in execute_multi fashion) Is there a more efficient way I should be doing this if I want to get the same performance as MySQL IN() ?

reyortsed avatar Apr 08 '11 09:04 reyortsed

Actually I just see that you have made a commit for IN support... I guess this will fix the issue.... cheers! //Steve

reyortsed avatar Apr 08 '11 10:04 reyortsed