Temp-table causes really slow quit

[rohan]

I wonder if someone can help me with this.

When I use temp-tables I get a delay after pressing the PF4 to quit the program. The larger the temp-table the longer the delay.
This delay could be around 30 seconds for the temp-table I have created. In this case the table has about 80,000 indexed records and just 3 small fields.
I have specified NO-UNDO on the temp-table.
If I explicitly delete the tt records before quitting this takes too long also.
What am I doing wrong, or is this just a slow hardware problem?
It is hard to believe the hw could be that slow for such a small table.

TEMP-TABLE example:

DEF TEMP-TABLE t-dlnote NO-UNDO
FIELD so-pref AS CHAR
FIELD so-number AS INT
FIELD despatched-d AS DATE
INDEX i-dl AS PRIMARY so-pref so-number.

Thanks,
Rohan

 

[Olivier_Desmars]

You have to know that TEMP-TABLE are written (and so read) on the hard-disk ! If your hard disk is slow, full or fragmented it will certainly decrease your performances.

You can also try to use WORK-TABLE (which are stored in memory instead of hard disk) but it does not support all indexes functionnality (as far as I remember).