Query result

• • Reply

  12 years ago

  by trafeeque

  Rafeeque Ahmed

  INDIA, India

  Joined 15 years ago

  Hi

  I have a table contains(15 fields) only 7000 records, table having primary key, indexing perfect.

  when I used connect database server through internet using IP address , while runing a small query like (select * from table)  in query analyzer, its taking 40 second to get the result... why its taking that much time of time to respond. What need to be done to get faster performace. Please help me out.

  Report abuse
• • Reply

  12 years ago

  by TimL

  Tim Leung

  Berkshire, United Kingdom

  Joined 13 years ago

  Personally, I don't regard 'Select * from table' over 7000 rows and 15 columns to be a 'small query'. If you're returning 7000 in query analyzer, you have to accept that it's going to take longer if the database server is on the other side of the internet than on your LAN. Supposing that each row contains 4k of data, 7000 rows equates to over 25Mb and 40 seconds is not an unreasonable amount of time.   

  The best thing you can do to increase performance is to do more towards returning just the data that you need.
  

  Report abuse