This seems like a fairly straight-forward challenge. However, I
changed the format of the date to make it compatible. (I assume this
does not invalidate the test?)

Using FB 1.0 and isql on a:
Dell OptiPlex GX240
Pentium 4 1.8GHz, 1Gb memory
Maxtor DiamondMax 60 Plus (Ultra ATA/100 7200rpm hard disk)

I ran two scripts:

----Script 1 creates the database----
create database "test.fdb" page_size 1024;

create table TB_LargeTable (
OneID INTEGER,
OneStatus char(1),
OneDate TimeStamp
);
----Script 1 end----

----Script 2 loads the database----
connect 'test.fdb';
insert into TB_LargeTable values ( 1 , 'A' , '2002-01-01' );
insert into TB_LargeTable values ( 2 , 'A' , '2002-01-01' );
insert into TB_LargeTable values ( 3 , 'A' , '2002-01-01' );
<995,000 records snipped>
insert into TB_LargeTable values ( 999999 , 'A' , '2002-01-01' );
insert into TB_LargeTable values ( 1000000 , 'A' , '2002-01-01' );
commit;
----Script 2 end----

Script 2 took about 7 minutes to run on my computer and generated a
58Mb database file.

Then, I opened the database using IB_SQL. I can browse through the
million records with ease.


Eric