The following procedure tasks 11 seconds to run: inserting about 90,000 rows
per second.

Is this to be expected?


connect "localhost:/u1/db/fill.fdb";
commit;
drop database;
commit;
create database "localhost:/u1/db/fill.fdb";
commit;

CREATE TABLE tbl_fill (
int_fill NUMERIC(18,0) NOT NULL PRIMARY KEY
);

CREATE GENERATOR gen_tbl_fill;

set term !! ;
create or alter PROCEDURE sp_fill
returns (
int_loop INTEGER,
dtm_time TIME
)
AS
BEGIN
int_loop = 0;
dtm_time = 'now';
suspend;
while (int_loop < 1000000) do BEGIN

INSERT INTO tbl_fill(int_fill) values (gen_id(gen_tbl_fill,1));

int_loop = int_loop + 1;
END
dtm_time = 'now';
suspend;
END !!
set term ; !!

set stat;
select * from sp_fill;