Refresh Problem

Our application is C++ and databases are Sybase. We are 11.5.1 Sybase. Lately some of our clients have complained about data refresh problems. That if a user has made some changes within the application then these data changes are taking long time to reflect to other users in the system. We do have in our application processes to automatically refresh data for other users but for some odd reason it is not working properly. Also every day we run sp_recompile and sp_stat on the tables and stored procs. Any ideas or leads ?

Thanks
Gohar

Are there any blocked processes ?

You may have locking issues.

Also, how many indexes are there on the tables ? The more indexes the slower the update/inserts/deletes will be.

Sorry if this doesn't help.


------------
Gohar at 3/22/01 8:33:20 AM


Our application is C++ and databases are Sybase. We are 11.5.1 Sybase. Lately some of our clients have complained about data refresh problems. That if a user has made some changes within the application then these data changes are taking long time to reflect to other users in the system. We do have in our application processes to automatically refresh data for other users but for some odd reason it is not working properly. Also every day we run sp_recompile and sp_stat on the tables and stored procs. Any ideas or leads ?

Thanks
Gohar