Forum Post: AW: Temp-tables

  • Thread starter Thread starter Mike Fechner
  • Start date Start date
Status
Not open for further replies.
M

Mike Fechner

Guest
But we are talking about millions of records? How large did your dbi file grow? The fastest way to get rid of the temp-table is to exist the program/delete the class that defined it. Followed by EMPTY TEMP-TABLE. For such large amounts of records keeping them in a local DB and deleting the DB when no longer needed will be much faster. Local DB’s and temptables are comparable in Performance (once the TT get’s too large for –Bt). Von: ankitshukla [mailto:bounce-ankitshukla@community.progress.com] Gesendet: Donnerstag, 14. Mai 2015 12:15 An: TU.OE.General@community.progress.com Betreff: RE: [Technical Users - OE General] Temp-tables RE: Temp-tables Reply by ankitshukla No I was not actually copying the DB records into temp-table. I was taking those records from a text file. Stop receiving emails on this subject. Flag this post as spam/abuse.

Continue reading...
 
Status
Not open for further replies.
Back
Top