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

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

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

Message

From

19/02/2004 07:56:56

Stuart Reid
Port Elizabeth, South Africa

To

19/02/2004 07:08:26

Fabio Lunardon
Lunacom
Marostica, Italy

General information

Forum:

Visual FoxPro

Category:

Coding, syntax & commands

Title:

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

Miscellaneous

Thread ID:

00878661

Message ID:

00878676

Views:

16

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