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 08:33:23

Fabio Lunardon
Lunacom
Marostica, Italy

To

19/02/2004 07:56:56

Stuart Reid
Port Elizabeth, South Africa

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:

00878679

Views:

14

Result cursor with sql 843 265

you really print 843 265 records ?

stock_code is invlines.stock_code ? I THINK YES.

Hovewer 800KB results need 3-5 seconds on a fast CPU (>2GHZ) with table on local filesystem.

Your exec time is ?

Fabio

Click here to load this message in the networking platform