php - Mysqli query fast enough? Or is there another way? -

php - Mysqli query fast enough? Or is there another way? -

i working on script 1 time again , have worries mysqli queries. script working on similar websites 9gag different background. listing bunch of entries in database , nowadays them users. after user logged in, or can or dislike each post. store or dislike in database prevent user liking or disliking post again. wondering, if simple:

$db->prepare("select id table id = ?");

would fast plenty if database continues bigger. guys think might improve store info in texfile in database? love hear thoughts this. maybe there improve , more of import faster way solve problem. give thanks much in advance , excuse bad english language :-)

if table has many rows can add together limit 1 (or 2, or 3, etc.)

$db->prepare("select id table id = ? limit 2");

in case when 2 rows found search ends.

if field after should indexed. click index in phpmyadmin field.

php mysqli