Professional Web Applications Themes

INSERT QUERY WEIGHT - MySQL

Hi I would like to know if there is a limit in mysql to the weight of an insert query, I mean which size of data can I insert in my table at the same time? Thanks...

  1. #1

    Default INSERT QUERY WEIGHT

    Hi I would like to know if there is a limit in mysql to the weight of an
    insert query, I mean which size of data can I insert in my table at the
    same time?
    Thanks
    max@utm-appliance.com Guest

  2. #2

    Default Re: INSERT QUERY WEIGHT

    What???

    [email]maxutm-appliance.com[/email] wrote:
    > Hi I would like to know if there is a limit in mysql to the weight of an
    > insert query, I mean which size of data can I insert in my table at the
    > same time?
    > Thanks
    LJB Guest

  3. #3

    Default Re: INSERT QUERY WEIGHT

    [email]maxutm-appliance.com[/email] wrote:
    > Hi I would like to know if there is a limit in mysql to the weight of an
    > insert query, I mean which size of data can I insert in my table at the
    > same time?
    Yes, there is a practical limit. But the limit might be much higher
    than what you require for your data inserts.

    The INSERT statement in MySQL supports syntax to insert multiple rows in
    one statement. Sometimes the entire contents of a table can be inserted
    in a single INSERT statement.

    I can't find doentation about a limit to the amount of data that can
    be inserted, but consider this: When inserting, MySQL uses a cache to
    help speed up bulk inserts. The default size of the cache is 8MB, and
    can be increased. So the software is designed to handle bulk inserts
    that potentially might be many times larger than this amount.

    Can you tell us how large your data can be? Perhaps the answer will be,
    "MySQL's limit is much higher than that."

    Regards,
    Bill K.
    Bill Karwin Guest

Similar Threads

  1. INSERT Statement Query
    By Murdoc in forum MySQL
    Replies: 9
    Last Post: August 20th, 02:37 PM
  2. Dynamic insert query problem.
    By Neopolita in forum Macromedia ColdFusion
    Replies: 0
    Last Post: April 27th, 07:27 PM
  3. SQL Insert Query using ADO
    By Tim johnson in forum ASP Database
    Replies: 1
    Last Post: August 20th, 03:14 AM
  4. Query to insert into current record
    By John Weinshel in forum FileMaker
    Replies: 0
    Last Post: July 26th, 01:07 PM
  5. DataAdapter Insert data into a query
    By Paul in forum ASP.NET General
    Replies: 0
    Last Post: June 30th, 06:47 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139