>I was having some performance problems with VFP5 using Views to load a form. I tested the performance of the view "requeries()" on the network vs the local drive. Over about 7 different views I found the total time to retrieve them from the net took 6 TIMES LONGER than from the local drive. I checked to see if the base tables were opened as shared on both local and net views, and they were, so there is no difference there. The view with the longest execution time (5-6 seconds) retrieves only 1 record from a one table of 17K records with a field length of 239 bytes (including 2 memo fields) no field calculations, no order or group by's, using a simple parameter statement (WHERE Lot.lotnumber = ?lcLotno AND lot.partnumber = ?lcpartno). We are on a Novell network using version 3.5 I believe. I am not a network expert, but maybe someone can tell me whats going on here. It even looks like it takes longer to do a USE IN TABLENAME on the net!
>
>HELP!
>
>tia
>tc
Hi Tony,

Be sure you have the database open and active before open the tables.
If you USE and xx doesn't belong to the open DBC or the DBC isn't open VFP has to look in the search path instead of open the table with the DBC information. Depending of the numbers of files and directories in your search path, I tested such differences could be as much as 500%. By the way, I have better performace open the permanent files from the server.