DROP DATABASE IF EXISTS mem; CREATE DATABASE mem; USE mem; CREATE TABLE t1 ( `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY(`id`) ) ENGINE = MyISAM; CREATE VIEW v1 AS SELECT * FROM t1; DELIMITER // DROP PROCEDURE IF EXISTS p1 // CREATE PROCEDURE p1(IN loops BIGINT(19) UNSIGNED) BEGIN WHILE loops > 0 DO SELECT id FROM v1 WHERE id = 5; SET loops = loops - 1; END WHILE; END // DELIMITER ; CALL p1(10000000);