Performance of Free tables compared to within a DBC 
Author Message
 Performance of Free tables compared to within a DBC

Why does it take much longer to open a table associated with a DBC than a
free table?
I have 20-30 tables to be opened (all read only reference tables, bound
inside an APP), and onsite it takes about 5 seconds to open these files.
This happens within every datasession that is created, so is quite a large
overhead.
I have changed to free tables, and the process is now almost instant.

VFP7 SP 1



Mon, 15 Aug 2005 09:22:52 GMT  
 Performance of Free tables compared to within a DBC
Do you keep closing the database and tables? After the iniital open, VFP simply creates a new set of
properties for the file, and does actually do a physical open on the file - datasessions and USE
AGAIN are logically the same. Is your system tight on memory? For the initial opening, is the server
tight on memory? Are you sure it's really the USEing of the files and not some other process in the
form opening that's taking the time? Are you using DEs, or "manually" opening the files?

Rick


Quote:
> Why does it take much longer to open a table associated with a DBC than a
> free table?
> I have 20-30 tables to be opened (all read only reference tables, bound
> inside an APP), and onsite it takes about 5 seconds to open these files.
> This happens within every datasession that is created, so is quite a large
> overhead.
> I have changed to free tables, and the process is now almost instant.

> VFP7 SP 1



Mon, 15 Aug 2005 22:32:06 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Free Tables vs DBC

2. DBC vs. Free Tables in ODBC

3. .dbc vs. free tables

4. Free tables vs dbc

5. Set relation problems between DBC and free tables

6. dbc VS Free tables

7. How to import hundreds of free table to one DBC

8. dbc vs free table

9. Free Tables to DBC - Is behaviour different?

10. performance of vfp 6 compared to 5

11. Moving tables from one .dbc to another .dbc

12. Need Feedback: Performance issues when using an application container within a form

 

 
Powered by phpBB® Forum Software