Insert Delayed

Discussion in 'MySQL' started by deriklogov, Nov 19, 2009.

  1. #1
    Hey,

    I need some one help
    I am using INSERT DELAYED with MyIsam table.
    I have a script which doing a lot of inserts , one by one,
    what I need from INSERT DELAYED is to bundle those queries together before
    inserting into database.
     
    deriklogov, Nov 19, 2009 IP
  2. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #2
    Your script should do this. When doing bulk inserts, adjust bulk_insert_buffer_size for better performance.
     
    mwasif, Nov 20, 2009 IP
  3. deriklogov

    deriklogov Well-Known Member

    Messages:
    1,079
    Likes Received:
    22
    Best Answers:
    0
    Trophy Points:
    130
    #3
    the thing is its very complicated to do bulk inserts as some of the inserts are going to different tables which is very hard to sort out.
     
    deriklogov, Nov 20, 2009 IP