Optimizing speed of SQL Select

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Optimizing speed of SQL Select

Message

From

08/10/2005 16:35:30

Guenter Huber
The One Man Half Time Computer Show
Neumarkt, Austria

07/10/2005 18:45:45

Dmitry Litvak
Massachusetts, United States

General information

Forum:

Visual FoxPro

Category:

Other

Title:

Re: Optimizing speed of SQL Select

Environment versions

Visual FoxPro:

VFP 6 SP5

Miscellaneous

Thread ID:

01057215

Message ID:

01057493

Views:

>...once I added two more fields to the WHERE expression the speed of the query is considerably better (3 seconds).

Overlooked this. 5 min. sounded like not solvable by a compound index.
All the best
G

Map

View

Click here to load this message in the networking platform