At 03:32 PM 3/24/2008 -0400, David Boatright wrote: >Charlie Coleman > >Are you joining those 2 tables in some way? > > >I don't use Views because I don't like the loss of control. Plus SQL syntax ... >They are not views just tables added to the data enviroment. ... >As I said i just created a blank form and added the two tables which are >located on another machine on the network. It takes upto 15 seconds for ...
I just created a new form - VFP form class (no subclassing). I added 4 tables in the DE. 1 with 12,500 records (table size > 11 MB), 1 with 5,900 records (table size 11MB), 1 with 560 records (size 810k), 1 with 36,000 records (size 4MB). There were no relations between the tables. When I ran the form it displayed instantaneously (less than 1 second). -Charlie _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
