As for creating Temp files in our system - I don't really have a choice - as I generally HAVE to follow the standard procedures. And, therefore - they are created on the Network.
Also - locking isn't an issue - since the Temp file ONLY exists and is seen by this program when it runs (Unique named generated and all...). -K- -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Richard Quilhot Sent: Wednesday, March 24, 2010 5:01 PM By using the local drive, you will get better performance. You won't have send & retrieve the data across the wire. Plus if you're in a multi user setting, you won't get any locking issues. Richard E. Quilhot C.N.A. [email protected] On Wed, Mar 24, 2010 at 4:51 PM, Kurt Wendt <[email protected]> wrote: > Richard, > > Thanks for the insights on the Cursors - as some of my assumptions about > them were wrong. > > In addition - for our system - there is this "Work" sub-directory where > temp files are created, and code in the system that generates the temp > file names. I only bring this up - because you suggested storing the > temp files on the local C: drive - while this work directory is up on > the Server - under the main directory where the application resides. > > So - shall I still go for doing a Temp DBF, along with a Temp IDX file - > even though its on the Server? Or - will a Cursor ACTUALLY get generated > as a True local temp file - because of the way VFP works? > > -K- > > > -----Original Message----- > From: [email protected] [mailto:[email protected]] > On Behalf Of Richard Quilhot > Sent: Wednesday, March 24, 2010 4:31 PM > > Basically your temp cursor is a temp dbf. The system writes the data to > system generated dbf that is auto deleted once your release the cursor. > I would write the code to use a temp dbf on the local PC, and do cleanup > when done. > > Richard E. Quilhot C.N.A. > [email protected] > > > > > On Wed, Mar 24, 2010 at 4:12 PM, Kurt Wendt <[email protected]> > wrote: > > > Hey folks, > > > > I'd like to get people's Opinion - or a little input - on this thing > I'm > > trying to tackle. > > > > One of our clients has a request from their Trading partner... > > > > So - for the changes I need to make to the Invoicing - I'm building > this > > Cursor... > > > > So - is just searching a Cursor of 3000 records like that - would it > end > > up being relatively slow...? > _______________________________________________ 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/289ea162f5642645b5cf64d624c66a14071a1...@us-ny-mail-002.waitex.net ** 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.
