View Single Post
Old 04-02-2009, 09:51 PM   #13 (permalink)
allworknoplay
The Gregarious
 
allworknoplay's Avatar
 
Join Date: Feb 2009
Location: New York
Posts: 645
Thanks: 64
allworknoplay is on a distinguished road
Default

Quote:
Originally Posted by Village Idiot View Post
If you are looking for a raw piece of text, it might be faster to search raw text, but it will without a doubt be more memory intensive because those functions tend to load it all into memory. If you are looking for anything more advanced than that, a database is probably your best bet.

You see, searching through raw text looks though every bit of it, SQL uses more advanced techniques so it doesn't have to do such a low level comparison.
Thanks, and you're right.

The SQL language alone offers many many commands that you can do easily whereas searching and performing functions on a text file you would basically be re-inventing the wheel somewhat...
allworknoplay is offline  
Reply With Quote