SQL Stmt into cursor too slow, How can I speed up? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

SQL Stmt into cursor too slow, How can I speed up?

Message

De

19/02/2004 07:56:56

Stuart Reid
Port Elizabeth, Afrique du Sud

À

19/02/2004 07:08:26

Fabio Lunardon
Lunacom
Marostica, Italie

Information générale

Forum:

Visual FoxPro

Catégorie:

Codage, syntaxe et commandes

Titre:

Re: SQL Stmt into cursor too slow, How can I speed up?

Divers

Thread ID:

00878661

Message ID:

00878676

Vues:

18

Details you asked for Fabio

Record Count
Customer 365 206
Invoice 366 405
InvoiceLines 846 166

Result cursor with sql 843 265

SYS(3054,11) - This was on the sql statment

Rushmore optimization level on table Customer: none
Rushmore optimization level on table Invoices: none
Rushmore optimization level on table InvLines: none

Joining table invoives and customer using index tag cu_recno

Joining intermediate result and table InvLines using
index tag invl_invrecno

Stuart Reid

True nobility lies not in being superior to another man, but in being superior to one’s previous self

Click here to load this message in the networking platform