Announcement

Announcement Module
Collapse
No announcement yet.

Does a table ALIAS affect performance?

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Does a table ALIAS affect performance?

    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.

  • #2
    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?

    Comment


    • #3
      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.

      Comment


      • #4
        Updates and inserts are your concerns. If you have any problems with locking, look at InnoDB (but don't run InnoDB with default settings).

        Comment

        Working...
        X