Does anyone know if a table ALIAS has any affect on performance, either positively or negatively? I’m asking since implicit table locks occur on an aliased table. I’m not clear what impact this has when other SELECT statements need to use the same original table.
I haven’t noticed any impact, nor have I noticed any table locks, and I use table aliases all the time. Are you using MyISAM or InnoDB?
I’m using MyISAM. I’m mostly not using table aliases right now, but I’m trying to determine where most of my table locks are coming from and didn’t know if adding aliases would help, hurt, or make no difference.
Updates and inserts are your concerns. If you have any problems with locking, look at InnoDB (but don’t run InnoDB with default settings).