View Complete Thread | FoxWeb Forum Home
Date:    Msg ID:   
From:    Thread:   
I agree with your comments.  In general FoxWeb is really fast opening tables, but in some cases where you are dealing with extremely large tables and complex index structures you can greatly improve the efficiency of your scripts by disabling the Close Tables option.
FoxWeb Support Team
Sent by John Potter on 04/16/2002 09:58:44 AM:


I see it's recommended that tables be closed as a program exit function but I'd sure rather not. After writing to a table I'd close it and reopen it again but otherwise I'd like to just leave everything open. It's a big speed difference.

Comments, Please.


John Potter





Close Tables
If this entry is checked (recommended) FoxWeb closes all open databases after execution of user programs. If this option is disabled, user programs will have to check whether a table has already been opened by a previous program before deciding whether to open it or select it. This option can be disabled in situations involving extremely large table/index files, in which there would be a performance hit if tables were opened and closed every time.