Skip to content

Instantly share code, notes, and snippets.

@icodeforlove

icodeforlove/insert_data.sql

Created September 12, 2013 19:27
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save icodeforlove/6542623 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save icodeforlove/6542623 to your computer and use it in GitHub Desktop.
Download ZIP
insert_data procedure takes about 230 seconds to run 1 million inserts
Raw
insert_data.sql
DELIMITER ;;
CREATE PROCEDURE insert_data()
BEGIN
DECLARE i INT DEFAULT 0;
WHILE i < 1000000 DO
/* QUERY */
SET i = i + 1;
END WHILE;
END;;
DELIMITER ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment