Walter Meester
HoogkarspelPays-Bas
>For a customer I have developed several applications. One of them is used to print a number of documents in a batch.
>Normally that applications creates a print within 25 seconds. However, if an other user start accessing the databases as well the batch speed (in fact all speed) drops to 2 minutes per print. Even closing the second application does not bring back the speed to the batch-application.
>
>Background:
>the applications are run from the local drive
>all data is residing on a NT-server
>both pc's are running Windows 95 (both are PII-300/64 Mb Ram)
>the databases are native VFP using DBC etc.
>the data gathering is complex using views
>
>Does any have a clue what is going on? Is this an application item, is it network related?
>
>Ron Brahma
Ron,
You might choose figuring out the SQL statement of the views and try to convert them into xBase statements. This might give you HUGE performance gains. See for references the current thread 'Wishlist: native VFP views'.
As for the performance drop when someone acces the database: it's probably due to buffermanagement of the NT network.
Walter,
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