Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>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. :>)
Yep... Just ran it only selecting 2 fields and it ran in 12 seconds. I think I'm going to use Doug's suggetion of starting out with a limited-field view for the users to select from. Then I'll go on to a full-field, but limited-record view when they choose the one to edit.
Still think it should run faster though...
Renoir
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement