Results 1 to 1 of 1

Thread: Inserting multiple rows at once - Overload ?

  1. #1

    Join Date
    Sep 2002
    Location
    Auckland
    Posts
    1,356
    Rep Power
    17

    Inserting multiple rows at once - Overload ?

    (I guess Powweb forums are very quiet these days)

    Hello.

    i am doing a new script (or sub-script), and I want to insert hundreds / thousands of records into a new table


    For now, I am scheduling this task & will only insert 2-3 records at a time as my scheduled-task allows.

    i am planning on using INSERT IGNORE - to insert records but only if not already present.

    Query: if i am doing a foreach loop - is there a maximum number of records I can insert at one time / go ? (for future reference).

    is it a good idea to only insert 5, 10, 50, 100 records at one time ? or can i actually do 500, 1000 without much trouble from the server ?

    QUERY 2: ive done a lot of research, and I cannot find an answer for this query: http://forum.powweb.com/showthread.php?t=96993

    this 2nd query (above) will be much better, as i can insert NEW records without re-checking old records to see if its already existing.
    Last edited by PeterPan; 5-3-14 at 01:19 AM. Reason: spalling arrars

Posting Permissions

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