Why MySQL where in (list) takes quite long? -
i try use mysql in (list) list 1000 items. takes me around 5 seconds. normal?
my query
select hex(hash) hash hash_table hash in (unhex("2c9ed97bb7cf48ddf74f"),....)
i have 10 million rows in hash_table.
how make faster?
Comments
Post a Comment