Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Wild Fire
  Where is Wild Fire?
 Davao / qc
 Philippines
 Wild Fire
 To: sqlpro
  Where is sqlpro?
 
 New Zealand
 sqlpro
 Tags
Subject: RE: vfp commands vs sql queries
Thread ID: 50737 Message ID: 50739 # Views: 1 # Ratings: 0
Version: Visual FoxPro 8 Category: Databases, Tables and SQL Server
Date: Monday, September 06, 2004 2:18:40 AM         
   


> If I write code with foxpro native commands to achieve what I want performance always good.but as you guys know what you can achieve in some 10 lines of foxpro code with some simple 2 lines sql syntax.
> What you guys suggest.Is this only way to achieve performance(I mean using foxpro native commands) or do I need to enable something vfp to speed up the queries.

There are times when Foxpro's native Filter command is a lot faster than SQL queries.
I'm talking about SET FILTER TO here.

Try also looking into Foxpro's Rushmore... probably it could help boost the performance.



ENTIRE THREAD

vfp commands vs sql queries Posted by Rajani @ 9/6/2004 12:42:10 AM
RE: vfp commands vs sql queries Posted by Wild Fire @ 9/6/2004 2:18:40 AM
RE: vfp commands vs sql queries Posted by Rajani @ 9/6/2004 3:05:51 AM