I've got a table in my database with 90,000 or so (it actually says ~82,944 right now, not sure what the ~ means?) and it gets updated every minute via a cron script. Sometimes during the update there will be inserts, sometimes deletes, sometimes updates, so it's really important to me that this table runs as smooth as possible. I realize most of this is probably going to be optimized in my php connection code, but I'd like to clear up some mysql questions as well.
Do I take a performance hit by having var chars and variable length fields in the table? Would it be better to just set them as chars of 255 in size? I have lots of hard drive space, so that's not a worry and I was thinking this might help.
Any tips in the right direction would certainly help.