store SESSIONID into MYSQL

[kante]

Id like to store for statistic purposes the SESSIONID into a stat table in MySQL.

I know the session id is a 32 chars string, so i shoul duse a varchar(32) column type.....

Do you know if it is possible to save this in some different way.... eg HEX number .. to save space on mydatabase?

Thank you

[tony_l]

you can ... but it is a bit of a trick....

There is a function in PHP called dechex()

It takes an integer and spits out the hex equivalent.... problem is, you will probably need to come up with an algorithm yourself to convert the letter parts to ascii - which would be binary -and then convert them to decimal and then convert them to hex. Alot of work for something as complex as a session id.

• a 32 bit number should not fill up your db quickly. Depending on your traffic - you may want to only hold values for a 30 day period of time, and run a crontab to clear out that table of values older than 30 days.

what type of statistics are you trying to run on a session ID? If you are trying to keep up with hits or visitors, try webalyzer or somethng similar.