rotastrain

it takes 15 seconds to return results.. in phpmyadmin it says it took 0.2 seconds but returns results after 15.. can i speed this up?

Hey people i would really appreciate advise on this i have a 10gb database 2 fields idno int primary key text longtext i need to run a simple select on this table select text from corob where idno in (1,2,3,4,5,6,7,8......upto thousand idnos) right now when i run this query it takes about 15 seconds is there any way what so ever to make this go faster. can i load something into ram?make some buffer larger?make some log?anything? also here is my explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE gold range PRIMARY PRIMARY 4 NULL 1000 Using where thank you for your help rota