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

ASP+MSSQL，读取查询数据非常慢

Discussion in '后端开发' started by BoBo, Oct 21, 2005.

  1. BoBo

    BoBo New Member

    Joined:
    Sep 29, 2005
    Messages:
    929
    Likes Received:
    0
    16个表，应该有150万条数据吧，有什么快速的查询方式？

    一般只需要5-6个字段列出来

    不用存储过程，因为我不懂
     
    #1 BoBo, Oct 21, 2005
  2. 小叶

    小叶 New Member

    Joined:
    Sep 4, 2005
    Messages:
    17,941
    Likes Received:
    33
    生成静态页.
     
    #2 小叶, Oct 21, 2005
  3. BoBo

    BoBo New Member

    Joined:
    Sep 29, 2005
    Messages:
    929
    Likes Received:
    0
    晕~只是查询，如论坛的搜索，查找ID为：小叶的所有贴子，按道理没可能这么慢啊，服务器只有1G内存，也不可能不够吧
     
    #3 BoBo, Oct 21, 2005
  4. 老林

    老林 New Member

    Joined:
    Sep 6, 2005
    Messages:
    10,580
    Likes Received:
    36
    用叶子分页　这种查询只要几秒
     
    #4 老林, Oct 21, 2005
  5. BoBo

    BoBo New Member

    Joined:
    Sep 29, 2005
    Messages:
    929
    Likes Received:
    0
    不是，一般取得的结果只有三四条，如果查到一个过百的，那个人就非常惨了

    但奇怪的时很慢啊，为什么会这样呢？有什么办法可以查到原因？
     
    #5 BoBo, Oct 21, 2005
  6. 老林

    老林 New Member

    Joined:
    Sep 6, 2005
    Messages:
    10,580
    Likes Received:
    36
    数据库油木油主键？
     
    #6 老林, Oct 21, 2005
  7. BoBo

    BoBo New Member

    Joined:
    Sep 29, 2005
    Messages:
    929
    Likes Received:
    0
    有，就算没有，分别应该也没这么严重吧？一个表时要等，现在十几个表基本上时超时
     
    #7 BoBo, Oct 21, 2005
  8. 老林

    老林 New Member

    Joined:
    Sep 6, 2005
    Messages:
    10,580
    Likes Received:
    36
    发上来让他们看看
     
    #8 老林, Oct 21, 2005
  9. Tameway

    Tameway New Member

    Joined:
    Sep 6, 2005
    Messages:
    1,286
    Likes Received:
    8
    无该经验，改用存储过程试下
     
    #9 Tameway, Oct 22, 2005
  10. jcking

    jcking Well-Known Member

    Joined:
    Aug 30, 2005
    Messages:
    22,282
    Likes Received:
    70
    发出了
     
    #10 jcking, Oct 30, 2005
(You must log in or sign up to post here.)
Toggle Width
Language
English (US)