Walter Meester
HoogkarspelPays-Bas
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hi dodi,
Just as an experiment. Just make the DBC, DCX and DCT containing the view read only and try the same excersize. Does it improve the situation. If so, there is a problem in loading the view defenition.
Walter,
>
>Why is the first run of a view so slow? (~3 minutes, file has 165K records, size 10.7 MB, cdx 9.6MB; then requeries take only 1-2 seconds; different story if more than one user on the system!)
>
>.EXE is on clients local computer, data on server; Visual FoxPro as file server.
>
>SAMPLE VIEW:
>SELECT * FROM tacust WHERE tacust.cmrno = ?mcmrno AND tacust.actflag = "1"
>(in the form, the user enters a customer number (into the variable mcmrno) then it requeries the view)
>
>CMRNO is already indexed in TACUST file.
>
>I did some research and tried different approaches. Tried using DEL tag on DELETED() but no improvement. I also tried adding ACTFLAG as index (for Rushmore optimization) but it did not help. SYS(3054,1) stated that Rushmore optimization level for table TACUST is none. I don't understand.
>
>We can't switch to SQL server because I can't justify the business case when only five users access the system.
>
>Any help would be greatly appreciated.
>
>TIA
>~Dodi
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