Post reply

SQL Server 2000

  • February 16, 2012 at 3:12 am

    #99953

    We have to get monthly report from the SQL Server 2000 Database obviously on month basis. We get it with GridView mode and with TextView mode as well.

    The question is why SQL takes so much time to retrieve data with TextView mode as it is quite easier to do the same process with GridView mode. , current the total records is 4,853,528, Is there any solution to make it faster ? (Fetching data with TextView mode). How can we improve it?? Increment in Hardware resources ?? (RAM or Processor etc.) what could be the way forward ??

    Kindly see the below table to see the performance difference,

    Data Fetched Mode Duration (TIME) Records

    Query Monthly report(G33) Grid View 4minutes and 9 seconds4,853,528

    Query Monthly report(G33) Text View 21 hours,20 minutes and 38 seconds 4,853,528

    We need this report every month, what is your suggestion for us for future report?

    Your valuable response will be highly appreciated.

  • February 16, 2012 at 3:21 am

    #1447734

    I never seen this type of difference by changing the resultset view.

    which report you are fatching first txt or grid ?

    java

  • February 16, 2012 at 3:24 am

    #1447736

    I am fetching monthly report with large amount of records, the same task does in 4 mins & 21 seconds if i get with grid view but I need it with text view and when i try, it took hours and hours..

    My question is, is there any way to make it fast?? by the increment in hardware resources (RAM, Processor) ????

  • February 16, 2012 at 3:28 am

    #1447740

    Please provide your query execution plan for better analysis.

    java

  • February 16, 2012 at 3:47 am

    #1447748

    Ok, take a step back...

    What report contains 5 million records? No one is ever going to read 5 million rows, so what's the purpose of the report?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 16, 2012 at 4:24 am

    #1447767

    hassanazmat (2/16/2012)

    but I need it with text view

    Why ???

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply