How can I optimize this query? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

How can I optimize this query?

Message

De

30/01/2005 15:11:28

Zakaria Al Azhar
Actuaris.Net
Tétouan, Morocco

À

30/01/2005 15:02:59

Fabio Lunardon
Lunacom
Marostica, Italie

Information générale

Forum:

Visual FoxPro

Catégorie:

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

Titre:

Re: How can I optimize this query?

Versions des environnements

Visual FoxPro:

VFP 8 SP1

OS:

Windows XP SP2

Database:

Visual FoxPro

Divers

Thread ID:

00982000

Message ID:

00982105

Vues:

47

>With 22K records into the outer table, the expected time for your select is max 100ms.
>
>Fabio

Fabio,

If you don't mind for jumping in, how did you calculate the expected time or in general how do you ecalculate the expected for a query.

TIA.

Zakaria al Azhar
My blog on Actuaris.net

Click here to load this message in the networking platform