Hello again, For what it's worth, one of the biggest (by a long distance) culprits we have managed to identify in terms of memory "eating" is a 3-table form that we regularly call in an iterative loop. More often than not, memory is not released/recovered when the form is exited, and we can find a 4GB swap file used up pretty quickly.
This problem may or may not be anything to do with the current memory discussion, but it's certainly a major problem for us. It doesn't seem to happen to the same extent with straightforward single-table forms, although this is something we are still testing. In general, though, does anyone have any general recommendations for efficient form construction/call/release? I'm thinking along the lines of (where possible) pre-setting all variables prior to calling the form, rather than having the form do the lookups, etc. Thanks Steven Privacy & Confidentiality Notice ---------------------- This message and any attachments thereto is confidential and intended solely for the person to whom it is addressed. It may contain privileged and confidential information. If you are not the intended recipient you must not read, copy, distribute, discuss or take any action in reliance on it. If you have received this information in error, please notify us as soon as possible on the telephone number shown. Thank you. Fitzpatricks. Tel: +44 (0)141 306 9000 Fax: +44 (0)141 306 9090 Web: www.fitzpatricks.co.uk --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [EMAIL PROTECTED] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
