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