Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Posts
    13

    Unanswered: Decrease Costs in INSERTS/UPDATES Queries.

    Hi,

    I wanna know how can I do to reduce the Costs of INSERT/UPDATE Queries that I have, but in some Traces of SQL Profiler, I see that this queries taken most performance of my server.

    Remember that all tables that I have are Indexed Tables with the default value of Fill Factor.


    Tanks,
    Pedro Henrique Nunes
    MCP-MCP+I-MCSENT4-MCSEW2K
    Sao Paulo - Brasil

  2. #2
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    The more indexes you have the longer an insert will take.
    On heavy insert systems (telecoms for instance) I only ever have a single clustered index on the identity column of the call table.

    For updates try not to update indexed fields, also do not extend the length of any fields then you should get a direct update in place (as long as you don't have triggers or replication enabled on the table) which is the fastest type (hope that statement is still valid).

    Otherwise make sure the transaction log is on a different device to the data and that you are not getting contention on the table.

Posting Permissions

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