|
MySQL vs. Plain text Logs - Help I am Ignorant.
I'm logging surfers to plain text files. These files are running megabytes/day. IP referrer, time using php's fopen fwrite fclose.
Other than the obvious benefits to searching the logs with queries instead of parsing text files, I have a few questions for you SQL gurus.
How would the same info logged to MySQL database compare in size?
How would the speed compare?
What problems could I run into that I'm not considering?
Basically, is it overall worth my while to convert the logging to SQL? I'm totally ignorant about SQL databasing when it comes to high speed adds/queries. All I have ever used it for is non-intensive size or speed wise applications.
Thanks Guys
|