Hello,
I'm doing this to search a db with 3,807,533 rows that's over 2.8GB in size
SELECT * FROM `titles` WHERE (title LIKE '%$search%') ORDER BY `id` DESC LIMIT 30
when doing so it takes about 20 seconds to search
server specs:
duel core Xenon 2.8Ghz
2GB ddr3 ram
how can I speed this way...