Glenn seems to have trouble posting. I got this answer off-list and I haven't seen it show up yet on-list, so let me forward it to the rest of you:
________________________________ From: Glenn Herbert [mailto:[EMAIL PROTECTED] Sent: Thursday, June 16, 2005 12:12 PM To: Stevenson, Charles Subject: RE: [U2] [UV] TRANS vs T-correlative: caching last record The answer is (a) inside TRANS() (it knows whether its coming from retrieve or basic). If you are curious why we use the trans mechanism within BASIC but never cache files or records, I believe it was done because within BASIC you can readily modify a record whereas with query you cannot, and it was deemed that you would always want the current state of the record. Hence, within BASIC you must ALWAYS retrieve the record off of disk first. Hence the perceived (and actual) slowness. PS. I have NO IDEA what is causing the extraneous email with Lynx in it. If anyone has any ideas why this happens (since I use Domino Notes w/Outlook Client) I would be greatly appreciative (email me off the group). ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of "Stevenson, Charles" <[EMAIL PROTECTED]> Sent: Thursday, June 16, 2005 2:51 PM To: <u2-users@listserver.u2ug.org> Subject: RE: [U2] [UV] TRANS vs T-correlative: caching last record Always good to get answers from both Glenn & Martin. I thank you both. But combining the 2 answers : - Is T-correlative smart enough to do the same caching as TRANS()? {glenn} A T-correlative calls TRANS under the covers. The t-correlative is parsed and then calls trans() to do all the work. and > The TRANS cache only operates in the query processor, not Basic programs. I'm still left wondering if T-correlatives do caching. If TRANS() caches only for RetrieVe and not Basic, is the caching happening (a) inside TRANS() (it knows whether its coming from retrieve or basic) or (b) by RetrieVe itself, in a layer above TRANS()? If (a), then I would expect T-correlatives to cache just like TRANS() If (b), then probably not. - cds ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/