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? _______________________________________________ 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.
