Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Speeding up query
Message
De
16/05/2008 13:05:31
 
 
À
16/05/2008 11:10:06
Chris Ross
Lothian Valuation Joint Board
Edinburgh, Royaume Uni
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01317018
Message ID:
01317672
Vues:
11
>I've updated my code and the search in general is much faster than before except in the instance of searching on Streetname or town only (These fields have indices set).
>
>A streetname or Town only search can take 30-45 seconds to return the results. There are 450,000 property records and about 30000 master level records but this seems excessive?
>

What does SYS(3054) tell you?


Tamar
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform