Temp-Table Creation is slowing down

[bobl]

Hi,

I have a temp-table(36 fields and 1 index) that is getting creating. But as it gets bigger the records created are getting slower.

create 1-1000 = 35sec
1000-2000 = 40 sec
2000-3000 = 45 sec
.....
11000-12000 = over 2 minutes

Has anyone come across this problem before?

Thanks

 

[TomBascom]

You have probably outgrown the RAM cache for temp-tables.

Look for DBI* files in your session:temp-directory that are growing (they initialize to a static value that varies by Progress version and certain startup params like -tmpbsize).

If the DBI file is growing allocate more memory by using -Bt.