SELECT speed depends on output size questions ?? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

SELECT speed depends on output size questions ??

Message

De

12/02/1999 11:48:15

Michael Levy
Cincinnati, Ohio, États-Unis

À

12/02/1999 10:13:42

Mark Gattis
Marquis Services, Inc.
Plano, Texas, États-Unis

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

Re: SELECT speed depends on output size questions ??

Divers

Thread ID:

00187003

Message ID:

00187056

Vues:

25

I agree with Ed's first point. VFP is taking all the time building the result set on disk. I'm curious, if you change the query to just return the count of the rows in the result set (COUNT(*)) does it still take as long?

-Mike

Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com

Click here to load this message in the networking platform