Handling large traffic

[eluser]ChiefChirpa[/eluser]

But if you’ve many data in the session a VARCHAR field is to small. You have to check the length of the fields content before you change it from TEXT to VARCHAR.

Which is only really a problem if:

1 - You use an old version of MySQL.
2 - You have some requirement to store far more than normal in the session.

For MySQL 5+ the size of VARCHAR is only limited by the maximum row size, which in theory lets you store up to 65,535 bytes, I'd suggest most people's session requirements fit into that very easily.