General information
Title:
App slows drastically when more than one user
I got a VFP5.0a application running on an NT server. The app goes over ODBC to Oracle to pull down personnel data into a remote view. The pull from Oracle is not fast, but since the data is not time critical, it only happens when the forms are first brought up.
There is no update allowed back to Oracle.
Was plagued with performance problems, especially on the last page of a pageframe that had a grid bound to a local view of a local table as a lookup mechanism. Upon activate, did a select of the view and a requery.
I did finally get the response time I was looking for somewhere in drivers or settings. We have no idea what sped it up, but didn't ask questions and cloned the test machine's hard drive over to the user's computer.
The remaining problem is; it runs fine unless I go to a second computer and run the app again. The second instance runs slow as can be, and also bogs down the first one. When I exit, then the first one speeds up again.
I open the database shared. All the forms have the tables and views in the data environment. The DBFs,DBC, etc. are all out on the NT server. Did I miss a property or command somewhere?
Thanks in advance
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only