SQL Server Performance

Retreving data from a huge table

Discussion in 'General Developer Questions' started by sabsonline, Sep 18, 2003.

  1. sabsonline New Member

    Hai

    I am facing a problem with MS Sql 7.0 table
    I have table with around 10 Lakhs of datas
    I have given indexes, and primary key constraints in this table

    My problem is when I try to retrive a query to this table its taking a lot of time
    FOr eg: "select * from tblDatausers where intSubscribeMode = 1"
    (say to get a data of 50 rows from directly from server take arnd 5 mintues or more)
    My local server is P1V system with 256 MbRam)

    Rest of the tables (having arnd 2 Lakhs datas )in this db is working fine
    I also try with SQL 2000, but same issue

    Is this is the problem with SQl Server or it can't handle large datas?

    Plz help?

    Gaurav-
    P.S. 10 Lakh - 1 million

    Sabs
    sabsonline, Sep 18, 2003
    #2

  2. satya Moderator

    Monitor the activity using PROFILER while the query is running and make sure DBCC checks and index rebuild is in place.

    Also check query execution plan from Query analyzer for this typical query.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
    satya, Sep 18, 2003
    #2

  3. gaurav_bindlish New Member

    Do you have an index on intSubscribeMode column? What is the density in this column?
    Avoid using * as it is inefficient to use.

    Gaurav
    Moderator
    Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
    gaurav_bindlish, Sep 18, 2003
    #2

Share This Page