Looking for some tips and tricks regarding how to use memory efficiently when coding in webfocus. Was wondering if anyone had some suggestions or could point me in the direction of some reference materials for this topic. I have been coding in webfocus for a little over a year now and am wanting to do more to refine my skill set.

We also are using focus files a lot when creating reports to help with performance and to allow quicker access to line by line detail. Unfortunately those focus files are starting to make an imprint in terms of memory usage so we would like to make sure that when we create these, we are optimizing them to make them as small as possible and only using them when necessary.

Would welcome any information that anyone can offer regarding this subject.

Thank you.

This message has been edited. Last edited by: Kerry,

How are you creating the FOCUS files ?

I am using the APP HOLD command to designate which app folder to hold the file to and hold as a focus database.
See sample below:

APP PATH ibisamp

APP HOLD focus_files
TABLE FILE CAR
PRINT
	CAR
	MODEL
	BODYTYPE
	COUNTRY
ON TABLE HOLD AS CAR_FOCUS_FILE FORMAT FOCUS
END
APP HOLD
-RUN

When I do this I get the following:

car_focus_file.mas
car_focus_file.foc

Hi jhasty,

Can you please provide a bit more details on what you are looking for? For example, I do not see any error messages or issues with your code, so additional info will help us better understand your question and then better pointers to come.

Cheers,

Kerry