count(*) VS num_rows
View Single Post
04-02-2009, 09:51 PM
Join Date: Feb 2009
Location: New York
Originally Posted by
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...
View Public Profile
Send a private message to allworknoplay
Find More Posts by allworknoplay