Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Very Poor Performance of SQL on Local Table
Message
De
12/02/2002 15:37:42
 
 
À
12/02/2002 15:26:25
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00618884
Message ID:
00619090
Vues:
23
Could be, I'm hitting a table with 18 fields, 33974 records. In the command window:
sys(3054,1)
open database \\myserver\mydata\lposdata.dbc
set database to lposdata
select * from stylesheet where unitsellprice > 10
after a clean boot. I can't see how a local drive select could be that much worse.


>Could Ren be selecting a lot of large fields? Would that make the difference?
>
>>I just did a quick SELECT from a table across the network, pulled 17k+ records from >34k on a very non discriminating field. No related index. .95 seconds. Rushmore optimization level for table - none. You do have a problem. :>)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform