Results 1 to 3 of 3

Thread: Do indexes help writes?

  1. 09-26-2005, 11:12 AM #1
    csdunaway
    csdunaway is offline Registered User
    Join Date
    Sep 2005
    Posts
    1

    Do indexes help writes?

    I have an application that is insertting thousands of records houlry. The server's hard drives are staying maxxed out. My boss says there is an index problem. I say it is a drive subsystem issue.

    Any help would be appreciated to understand this performance problem.
    Reply With Quote Reply With Quote
  2. 09-26-2005, 12:11 PM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Indexes will degrade write performance on a table. As new rows are added or existing ones are updated all the indexes in the table need to be updated as well.
    Reply With Quote Reply With Quote
  3. 09-26-2005, 06:45 PM #3
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    You may have problem in both, double check with perfmon to see which one is worse.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules