I have not had to do hard coded SPT for a long time (just ODBC). But, I do not see why that would not work just as well if the SPT fetches its records in the background. It is worth a shot. You have nothing but speed to gain, and time to save <g>.
Gil > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of MB Software Solutions > General Account > Sent: Monday, March 24, 2008 3:16 PM > To: [EMAIL PROTECTED] > Subject: Re: VFP and PostgreSQL used to process FTC DoNotCall updates > > > Gil Hale wrote: > > Actually, I happened across that technique out of a desperate situation > when > > I was working with a Remote View on a Pervasive database table > with over 60 > > million records. But I was actually using GO BOTTOM at first, > in an effort > > to force the data to come over more quickly than its > lolly-gagging slow-mo > > default speed. It was a life saver, worked great. I spoke > with Ed about > > it, then posted it as an Advisor Tip. Ed responded in the > printed tip by > > stating the GO BOTTOM works fine, but it moves the record pointer. If a > > person did not want to move the record pointer one could do > RECCOUNT() and > > get the same performance result. Of course he was right, and I > have opted > > to use RECCOUNT() ever since, just in case I do not want to > move a pointer. > > > > > > This is only when dealing with remote views, correct, and NOT with SPT > cursors, right? > > > > > [excessive quoting removed by server] _______________________________________________ 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.
