Instead of a field names like: time, lastseen, current page etc I use numbers like 1,2,3. And instead of the info in fields I use 1 or 0 instead of 'yes' or 'no, or 'on and 'off'. What do you think? I think this would really boost the performance.
Heres my view; based on if another person views your code... I disagree, and would'nt do this, simply because databases can become large, and numbering columns can make it confusing. Theirfore it would be best to just leave them with names, as it would be easier to recognise and understand. However, I agree on this, as this would make no effect on anyone who has php knowledge to understand (since its just how boolean works).
It's look like enumeration, I prefer to save the name of enumeration rather than the value. It's will make you confuse to know the name from database.
It can make things very confusing, it would make it easier just to use names. But if you can understand it go right ahead.
That would get confusing with column names and theres no obvious advantages with performance. But using 0 and 1 makes sense, boolean.
It's ok for a small script, but if you then go onto a large project, if you're memory isn't excellent, then you'll find you have to keep referencing to see what equals what, and it can get confusing :S
agree on the memorization aspect with Grit. guess you could set your coding up so you use the same basic format using your system but it seems to me to be unnecessarily confusing.