On Dec 5, 2007 12:39 PM, Dan Olsson <[EMAIL PROTECTED]> wrote: > At 2007-12-05 17:43, you wrote: > >I've got a process where I'm copying files from the LAN to a local > >disk temp folder. The operations performed on that local copy are > >somewhat intense, so I was going to open it EXCLUSIVE in hopes of > >optimizing any possible performance. Since it's already local, and > >as such exclusive because no other user will access it (even the > >current user as it's put into a random temp folder generated on the > >fly), it'll already be quick I would expect. I just wondered IN > >THEORY if using the EXCLUSIVE clause would make a difference or not. > > Well, it should - since FP has no other way of knowing that you are > the only user that accesses the files, so by default it locks/unlocks > records as necessary. > > BTW (which I'm sure you know) - an easy way to do this is to SELECT > the required records/dbfs into a CURSOR, which automatically makes it > exclusive - AND FP will take care of the housekeeping for you, ie > deleting stuff when you're done using it. >
I don't think it does that all the time, does it? I mean if your code is : use mytable in 0 Select * from myTable into cursor mT You don't get a copy of the table into ram, you just see a fake copy of the table. Correct? Say the table was 500 meg. The select isn't doing a copy to a temp table first. Or am I remembering some other process? --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ 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.
