Hello ExpertS,
How i can resolve my problem of inserting record to my table having 14 million of records.

Here are the details.
Firebird Server : 1.5.x
OdbC : 1.2 ver
Size of Database : 3.7 GB

Windows Xp Pro 32bit
Intel Dual Core 1.6Ghz
2GB DDR3 RAM
5400 rpm SATA drive

The table that taking time to insert has
3 Primary key's and 3 Index and 12 FIELDS

the stored procedure command to insert to the table is :

INSERT INTO targetTable(field1,field2,field3)
SELECT field1,field2,field3 FROM sourcetable

if i run the procedure , it takes time to insert to mytable, but if i
create a empty table, it runs fast.

thanks in advance.