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

Fabio Lunardon
Lunacom
Marostica, Italie

À

19/02/2004 07:56:56

Stuart Reid
Port Elizabeth, Afrique du Sud

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:

00878679

Vues:

15

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