Derek Kalweit wrote: >> Quick question: are you using Views to access the data? >> > > Yes and no. Yes, our application uses views. No, the views are not in > use when this problem first occurs(on load). There were also no views > in the test app I created for TS. > >
I'm starting to take a different, hybrid kind of approach where I use views for retrieving but then just do inserts/updates/deletes directly into the VFP or MYSQL tables. Not sure if this simplifies or complicates, but so far, so good in my experiences. I'm wondering too if it aids at all in network traffic management? Probably not with VFP. But I recall VB6 learning about ADO recordsets and the various types of cursors you could create (e.g., "forward only" being the least network intensive). -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com "Work smarter, not harder, with MBSS custom software solutions!" _______________________________________________ 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 ** 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.
