I have found my website login user activity in a .txt file. I want to be able to show these results in my admin pages in the admin area. Therefore, 1 to 50 results from page 1 shows.
But I have the problem that it is set in the .txt file
User: Admin IP address: Xx.xxx.xxx.xx Host address: xxxxxxxxxxxxxxxx Date and time: Monday 20 September 2010 11:44:18 AM URL: Browser: Mozilla / 5.0 (Macintosh; U. Intel Mac OS X10_6_3; N US) Apple WebKat / 534.3 (like KHtml, GECO) Chrome / 6.0.472.62 Safari / 534.3 Rifting URL:
Seven lines interval between each set of information I was thinking about putting in a MySQL table, but it will not be very large over time?
Any help is appreciated!
What if it gets bigger? What is this database?
I have to assure you that the cost of setting up a database [one time] and a table homebra (custom-format) will be much less than maintaining the data file in the long run.
If you want to know what happened in the IP address 1.2.3.4 between 2010-09-25 and -26? Would you write a function? (This is a statement in SQL.) Are you going to scan the entire file? (The appropriate DBMS will only use index. MySQL will use at least one index.)
I say "try both of them and see how the DB approach wins for a long time" because The profit list is too much
Comments
Post a Comment