KMoody
Member
I'm populating a dynamic temp-table for a browse widget.
The user can request:
Here is the main section of my temp-table population:
Is there any way to make this faster, or is the slow performance unavoidable with such large tables?
(By the way, I'd like to thank everyone who's helped me out recently. ProgressTalk is a really valuable resource.)
The user can request:
- the table,
- the where condition, and
- which fields to show.
Here is the main section of my temp-table population:
Code:
DEFINE VARIABLE ttxx AS HANDLE.
DEFINE VARIABLE hbuf AS HANDLE NO-UNDO. /* Default buffer object */
CREATE TEMP-TABLE ttxx.
ttxx:CREATE-LIKE ("{&File}").
ttxx:ADD-NEW-FIELD("UID","ROWID").
ttxx:TEMP-TABLE-PREPARE("ttxx").
hbuf = ttxx:DEFAULT-BUFFER-HANDLE.
FOR EACH {&File} WHERE {&Where} NO-LOCK:
hbuf:BUFFER-CREATE ().
hbuf:BUFFER-COPY(buffer {&File}:HANDLE).
hbuf:BUFFER-FIELD("UID"):BUFFER-VALUE() = ROWID({&File}).
END.
Is there any way to make this faster, or is the slow performance unavoidable with such large tables?
(By the way, I'd like to thank everyone who's helped me out recently. ProgressTalk is a really valuable resource.)