Ricardo,
I have found out what the problem is. My database has a lot of updateable views in them. I use these to update the underlying tables. I also use them when printing. When the application is printing without any other user sharing the data there is no problem. If any other user starts using the views for printing both applications suffer.
I have modified my print program so it does not use the view but queries the tables with the sql-statement of the view. This works and now my application is back on printing speed, even if more thatn user is printing data. Infact, the performance level has increased because I'm no longer using the views for the print. It seems that the SQL executes a lot faster and is more stable than the view that does the same. Having views that can update tables was the problem.
Thanks for your response,
Ron Brahma
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