Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>I have a form that takes a fair amount of time to open. I added a
>>set talk on nowindow
>>to the BeforeOpenTables method to display what is happening.
>>
>>One table/view is taking a long time to open, however I would like to know what it is.
>>
>>How do I do this, the above talk command doesn't give me the alias(), just how long the queries take...
>>
>>Any ideas?
>>
>>TIA,
>>Mike
>
>SET COVERAGE TO may give you something but the surest way would be taking views one by one out of DE and checking time again.
By further investigation, one of the views had a parameter and there was no index on the repective fields... creating index - speed things up to fractions of a second...
Thanks,
Mike
Précédent
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