Hi guys.

Hope you are well, I'm currently encountered a problem about SQL searching efficiency as I need to read queries one by one from a file (assuming that each line represents a query) and then display total results together. My original codes work well if there is only one query available, but now the speed is very slow as it needs to look through the database (about 500MB) everytime it has found a new query.

So guys, do you have some idea on how to improve the efficiency? Many many thanks!

Nan