Results 1 to 2 of 2

Thread: Refresh Problem

  1. #1
    Gohar Guest

    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

  2. #2
    Phil Mc Guest

    Refresh Problem (reply)

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •