factors affecting inserts
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: factors affecting inserts

  1. #1
    Join Date
    Feb 2000
    Location
    New York,U.S.A.
    Posts
    245
    Hi,
    I have some questions to ask for help.

    1,What are the factors affecting the insert statement in a sql statement?
    2,How can I get the effect of parallel insert?
    3,Say, if I want to improve the speed of inserting into a table, what should I do?
    4,Will create table partitions help to improve the insert speed?

    Our database is running on Sun Solaris, version 8.1.7
    Thanks for help.

    Dragon

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Originally posted by dragon99
    Hi,
    I have some questions to ask for help.

    1,What are the factors affecting the insert statement in a sql statement?
    2,How can I get the effect of parallel insert?
    3,Say, if I want to improve the speed of inserting into a table, what should I do?
    4,Will create table partitions help to improve the insert speed?

    Our database is running on Sun Solaris, version 8.1.7
    Thanks for help.

    Dragon

    1. The system I/O, network bandwidth, ARRAYSIZE.

    2. Break them down to multiple smaller files and load them simultaniously.

    3. Have the FREELIST set appropiately on the table, if you are on the multi processor system follow the step 2, disable all the indices and triggers on the table. Once you complete the insert rebuild your indices for that table.

    4. If you have a bad network, then partition wouldn't help, but in general, partitioning across multiple tablespace should help you to a good extend.

    Hope this would help you.
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Feb 2000
    Location
    New York,U.S.A.
    Posts
    245
    Thanks, Sam.
    It is very helpful.

Posting Permissions

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



Click Here to Expand Forum to Full Width