Filesystem or database
| From: | Ryan A | Date: | Mon, 01 May 2006 12:13:37 +0000 |
| Subject: | Filesystem or database | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-235186@lists.php.net to get a copy of this message | ||
Hi,
This is just a quick query as I am bit doubtful of the
result..
basically, I get the username and ip of a person who
logs into a remote site and i have to save this data
(please note that this would be thousands of logins)
so I was wondering if it would be better to save the
username and ip as an empty file where the filename
contains both...
e.g:
<username>:<ip>
or in plain english:
my_username:201.1.1.22
This would save me in hundreds/thousands of calls to
the database and would (in theory) be faster as I
would be accessing the filesystem instead of the
DB....
Right?
Sometimes i get no username but just the ip address,
in which case I will first have to see if this IP is
already "logged" by me, and if yes, match the username
to the ip.
All usernames:ips expire in 1-24 hrs, I will be
running a cron to 'cull' these dead logins.
Am I on the right track or is it too much of a hassle
and just go in for the database option?
Thanks!
Ryan
------
- The faulty interface lies between the chair and the keyboard.
- Creativity is great, but plagiarism is faster!
- Smile, everyone loves a moron. :-)
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com