EXECUTE BLOCK
AS
DECLARE VARIABLE I INTEGER = 30000000;
BEGIN
WHILE (I > 0) DO
BEGIN
I = I - 1;
INSERT INTO IMAGES(IMAGE_PATH)
VALUES(RPAD('A', 249, 'A') || :I);
END
END

30000000 record(s) was(were) inserted into IMAGES

------ Performance info ------
Prepare time = 0ms
Execute time = 26m 11s 367ms
Current memory = 143 986 040
Max memory = 155 591 640
Memory buffers = 8 192
Reads from disk to cache = 3
Writes from cache to disk = 731 623
Fetches from cache = 272 831 184


update images set image_path_temp = image_path

Plan
PLAN (IMAGES NATURAL)

30000000 record(s) was(were) updated in IMAGES

------ Performance info ------
Prepare time = 0ms
Execute time = 29m 40s 533ms
Current memory = 146 625 296
Max memory = 158 234 936
Memory buffers = 8 192
Reads from disk to cache = 671 730
Writes from cache to disk = 208 182
Fetches from cache = 351 172 183