Filesystem or database

From: 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

« previous php.general (#235186) next »