EbrahemSamer
2 months ago
201
4
General

How to speed up search ( 1 million record ) PHP & MYSQL?

Posted 2 months ago by EbrahemSamer

I am searching on table using query like this

select * from table_name where f_name = .... and l_name = ..... and gender = male and ... ............. etc

the result shows in 3 seconds, is there is any thing i can do to make it fast.. ( I am using PDO ).

Please sign in or create an account to participate in this conversation.