> I've heard this tip before. Wonder why it is the way it is? Why does > something so innocent/simple like that really add the POW! to the > equation I wonder? >
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. Gil > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of MB Software Solutions > General Account > Sent: Monday, March 24, 2008 12:10 PM > To: [EMAIL PROTECTED] > Subject: Re: VFP and PostgreSQL used to process FTC DoNotCall updates > > > Gil Hale wrote: > > <snipped> One of my little tricks I use for > > SQL-SELECT processing with fairly large VFP tables (3 million > records, 78Mg > > table) about came in handy when pulling records with my VFP > parameterized > > view when the PostgreSQL records came over real slow. I issued a > RECCOUNT() > > (after performing a REQUERY() with the new Parameter value) against the > > Parameterized View, and POW! The records flew over pronto! Works great > for > > the 78Mg table following a SQL-SELECT, works just a well for the much > larger > > PostgreSQL table result set! > > > > I've heard this tip before. Wonder why it is the way it is? Why does > something so innocent/simple like that really add the POW! to the > equation I wonder? > > > > > [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.
