1. 论坛系统升级为Xenforo,欢迎大家测试!
    Dismiss Notice

字段和表太多会影响数据库效率吗?

Discussion in '后端开发' started by laogui, Aug 24, 2007.

  1. laogui

    laogui Administrator
    Staff Member

    Joined:
    Aug 30, 2005
    Messages:
    15,216
    Likes Received:
    35
  2. notnull

    notnull New Member

    Joined:
    Sep 27, 2005
    Messages:
    11,720
    Likes Received:
    37
    这是不存在的
    除非你设计不合理
     
  3. yeshou

    yeshou New Member

    Joined:
    Sep 6, 2005
    Messages:
    7,067
    Likes Received:
    34
    同意2楼
     
  4. Kevin

    Kevin New Member

    Joined:
    Oct 23, 2005
    Messages:
    12,728
    Likes Received:
    55
    主要是看一次查询的数据多少吧?
     
  5. notnull

    notnull New Member

    Joined:
    Sep 27, 2005
    Messages:
    11,720
    Likes Received:
    37
    在适当的列建好索引
     
  6. wm_chief

    wm_chief New Member

    Joined:
    Sep 5, 2005
    Messages:
    17,890
    Likes Received:
    46
    字段多当然会影响。