34,333
edits
Changes
→Inserting Results from a SELECT Statement
product_quantity
FROM old_products;
</pre>
== Reducing the INSERT Performance Load ==
The INSERT satatment places a relatively high load on the database server. In fact a high volume of insertions can have an adverse effect on other transactions (such as reading data). To reduce the load imposed by a data insertion consider using the ''LOW_PRIORITY'' keyword. For example:
<pre>
INSERT LOW_PRIORITY INTO products(
product_id,
product_name,
product_description,
product_location,
product_quantity)
VALUES(
NULL,
'CD-RW Model 4543',
'CD Writer',
'Shelf 4B',
10
};
</pre>
== Reducing the INSERT Performance Load ==
