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

Popular posts from this blog

php - Admin SDK -- get information about the group -

-
please, help. https://www.googleapis.com/admin/directory/v1/groups/106274944935548788283 sending request obtain information group id 1062 ... here link method in google https://developers.google.com/admin-sdk/directory/v1/guides/manage-groups#get_group in response error - 401 unauthorized. oauth authenticate via user has received rights necessary request, included in console admin sdk. authorization successful, there token. not can not understand. if not hard - response. requested information: file_get_contents("https://www.googleapis.com/admin/directory/v1/groups/1062749‌​44935548788283?key=aizasybruhiomdf9nlx9lx3imxwesqmcrnhh4l4"); id group - "106274944935548788283" key applications in case - "aizasybruhiomdf9nlx9lx3imxwesqmcrnhh4l4" error: failed open stream: http request failed! http/1.0 401 unauthorized
Read more

javascript - Updating a Nested Array with MongoDB -

-
i trying update value in nested array can't work. my object this { "_id": { "$oid": "1" }, "array1": [ { "_id": "12", "array2": [ { "_id": "123", "answeredby": [], }, { "_id": "124", "answeredby": [], } ], } ] } i need push value "answeredby" array. in below example, tried pushing "success" string "answeredby" array of "123 _id" object not work. callback = function(err,value){ if(err){ res.send(err); }else{ res.send(value); } }; conditions = { "_id": 1, "array1._id": 12, "array2._id": 123 ...
Read more

c# - PHP script ,MySQL -

-
i'm writing php script. need client-server communication database. i want count how many id's there in dtb, wrote this: $id= mysql_real_escape_string($_get['id'], $db); $query = "select count( id ) scores id = $id;"; $result = mysql_query($query) or die('query failed: ' . mysql_error()); my php skills low... send in parameter id php script, , count id's in table. don't know how return result (integer) php c#; my c# script ienumerator idexist(int id) // ci id existuje { string post_url = getid + "&id=" + id; www hs_get = new www(post_url); yield return hs_get; if (hs_get.error != null) { } debug.log(hs_get.text); } thanks answers. change code $query = "select count( id ) scores id = $id;"; $result = mysql_query($query) or die('query failed: ' . mysql_error()); to $query = "select count( id ) `total_ids` scores id = $id"; $result = mysql_query...
Read more