Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ODBC and Indexes

Status
Not open for further replies.
huwdm

huwdm

IS-IT--Management
Jul 7, 2004
2
GB
Does anyone know whether VFP indexes are used automatically with ODBC connections?
We have tried connecting to DBF files using MS ODBC for VFP using VB and Delphi - all appear to be slow.
 
Sort by date Sort by votes
You might get a better answer in the VB or Delphi forums. VFP programmers typically access VFP tables natively, not through ODBC.

Mike Krausnick
Dublin, California
 
Upvote 0 Downvote
Yes, ODBC will use the indeces. However, you may be better off using the VFP OLE DB provider.

Craig Berntson
MCSD, Visual FoxPro MVP, Author, CrysDev: A Developer's Guide to Integrating Crystal Reports"
 
Upvote 0 Downvote
Also, you may want to evaluate what indexes exist... make sure they are ones that Rushmore can use for optimizing, and that the WHERE clauses in the SQL commands passed over ODBC are optimizable.

- Bill

Get the best answers to your questions -- See FAQ481-4875.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

SitesMasstec
  • Locked
  • Question
Create a table with Tag indexes 1
Replies
13
Views
2K
TamarGranor
TamarGranor
Chris Miller
  • Locked
  • Question
ODBC specifications
Replies
6
Views
920
Chris Miller
Chris Miller
WedHouse
  • Locked
  • Question
odbc 1
Replies
12
Views
683
Chris Miller
Chris Miller
Steve-vfp9user
  • Locked
  • Question
WhatsAPP and VFP9 SP2 2
Replies
4
Views
1K
Paul Gibson
Paul Gibson
Joe Crescenzi
  • Locked
  • Question
Fun FoxPro Quirk using NOUPDATE and AGAIN together
Replies
11
Views
691
Chriss Miller
C

Part and Inventory Search

Sponsor

Back
Top