Post reply

Performance When Query Thru more rows

  • August 13, 2004 at 6:19 am

    #161310

    I have around 70000 rows. I want to run a query which speeds up the performance. since now it takes more time and the web page nearly says 'Timed Out'

  • August 13, 2004 at 7:28 am

    #518854

    What's the query?

  • August 14, 2004 at 12:49 am

    #518995

    select * from confirmation where job_loc = @job_loc and client = @client and experience > @min-2

  • August 14, 2004 at 3:33 am

    #518998

    Hi,

    Do You have appropriate indexes on the table ?.

    And what is the Primary key on the table ? - ( is job_loc + client the pk ? )

    From the query I derive that the query would benefit from indexes on the columns job_loc and client.

    Have You tried executing the query from QA to see what the performance is ?

    One last thing:

    instead of select * from ...

    do

    select cola, colb, colc,,,, from ....

    It is better practice to explicitly select the columns you are interested in.

    This will benefit You in the long run.

    /rockmoose


    You must unlearn what You have learnt

  • August 17, 2004 at 6:29 am

    #519315

    Dear Joseph

    I don't think so that only 70000 records will take that much time so that your page will expired, probable there must some other reason.

    any way first of all you make index on your table and make any field as primary key so that it will speed up your SQL QUERY's performance and also check the time take by your query on the QUERY ANALYZER in the bottom right  position it will show u the duration taken by the server to process your query !!!!!

    Have a nice time !

     

     

    - Manish

  • August 17, 2004 at 9:07 am

    #519367

    Look at the execution plan in QA to see what the process is doing.

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

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