1 Topic by mixart (edited by mixart 2008-05-31 11:12)

  • Registered: 2007-12-26
  • Posts: 57

Topic: Any benefit in removing unwanted fields in user table?

There are many fields in my user table that I don't use, mostly the IM fields but also a few others - MSN, AIM, JABBER (who uses jabber any more haha), etc.

I've also modified my UI to hide these fields wherever they exist and also modified my queries to never select them.

My question is, is there any performance benefit in me deleting them to reduce my database field count, size, etc.
Also - would deleting these fields make future punbb updates difficult? I know updates will always be a pain for me anyway since I have a highly custom modded forum.

2 Reply by hcgtv

  • hcgtv
  • hcgtv
  • Senior Member
  • Offline
  • From: Charlotte, NC
  • Registered: 2004-06-25
  • Posts: 1,991

Re: Any benefit in removing unwanted fields in user table?

The downside is that it makes upgrades difficult, and I don't see any benefits.

PHPCrossRef . TXP Make . TXP Themes . TXP Tags . TXP Planet . We Love TXP

hcgtv's Website

  • Connorhd
  • Connorhd
  • Former PunBB Developer
  • Offline
  • From: Leeds, UK
  • Registered: 2004-06-13
  • Posts: 4,195

Re: Any benefit in removing unwanted fields in user table?

tbh, its unlikely the 1.2 branch will change much and by the sounds of it you'll be editing files manually to upgrade anyway, so i don't think thats much of an issue, I doubt you've got much of a speed/space benefit though.

FluxBB.
Connorhd.co.uk.

Connorhd's Website