mysql or Preg_grep?

[loll]

Hi,

I have a file with about 200,000 lines in it (about 3mb i think).

Right now I have put it all into a mysql database and to retreive what I want I use mysql's regex to get the restuls out i need.

The regex in mysql seems to use up a lot of CPU time when it is getting hit regularly.

So I am wondering if loading the file into an array and using preg_grep to extract the data that way would be faster/lighter on the server?

Or is there another method that would be better for this sort of thing?

Thanks for any help that you can give.

[Weedpacket]

Dunno about if/how you can improve things MySQL-side (seeing as I don't use it myself and I don't know how you're using it), but if you wanted to do it PHP side, you'd have to get all the potentially relevant data from the database from MySQL into PHP. And that's before you even start searching with preg_grep().

If that involves less server load than doing it in MySQL directly, then it's not a good look for MySQL.