Which is quicker ...MySQL vs Flat file?

wxdqz

New Member
Hello all,

Was wondering if anyone knows which scenerio would be faster and why.

I want to store some session info such as a randomly generated alpha-numeric string 8 characters long, the userid and the date/time.

When each page of the website is loaded, I want to verify that the person has logged in (which was stored in the session info with successful login).

I know the sql SELECT could be specific in just looking for the session id (passed through the url)...but a connection, clearing of results and closing of the connection is needed each time. Wouldn't spinning through the records in a flat file just be faster? (I would have a cron job that would clear that flat file/DB every 12 hours or so).

I don't want to use cookies because many of my clients have systems that don't support them.

Thanks in advance!

gary
 
Back
Top