Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Network:
Windows 2003 Server
Al
Thanks for the reply
I've done as you suggested and same performance all around. But I rewote the view into smaller views with response times that are back to the original single computer time or better. It appears that the 15megs worth of CDX files were slowing the view down.
Thanks
Jon
>>Turned off the anti-virus and get the same response times.
>>
>>I've looked further and it appears that the issue is the cacheing of the CDX files is causing the problem. Why would it take longer to read the CDXs when two users are looking the the same files. Any ideas?
>>
>>Jon
>>
>>>>Sometimes this sort of behavior has been attributed to antivirus software, especially the one from Norton. Try to disable it (briefly, for testing only), or to exclude scanning of data files (*.dbf, *.fpt, *.cdx).
>>>>
>>>
>>>I'll give it a try.
>>>Jon
>
>If there is AV on the server as well as the workstations, did you remember to temporarily turn it off as well?
>
>Also, have you checked that it's not some sort of issue with 1 of the workstations? For example, suppose you have 2 workstations, A and B:
>
>- You've tested with just A -> fast performance. You've tested with A + B -> slow performance.
>
>Have you also checked:
>
>- Test with just B -> performance? Then test with B + A -> performance?
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