Results 1 to 5 of 5

Thread: Data Concurrency:

  1. #1
    Join Date
    Apr 2007
    Posts
    23
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Default Data Concurrency:

    I our company we have a online portal that sales executives use for updating stats about their customers...But what happens is if two executives are updating the same data, both clashes and the whole data is gone... somebody please tell me how to resolve this issue...


    FOI:

    Web Application : ASP.NET 2.0
    Database : MS SQL Express

  2. #2
    Join Date
    Jun 2005
    Location
    英国
    Posts
    11,876
    Thanks
    1
    Thanked 180 Times in 172 Posts
    Blog Entries
    2

    Default

    But what happens is if two executives are updating the same data, both clashes and the whole data is gone...
    Stay away from MSSQL. It's really not nice -- this should never happen, for a start. The most recent update should take precedence. You may be able to work around this problem (I'm tempted to call it a bug, but it's probably a feature), or at least reduce the likelihood of it happening, by performing a transaction like the PostgreSQL
    Code:
    BEGIN;
     ...
    COMMIT;
    Twey | I understand English | 日本語が分かります | mi jimpe fi le jbobau | mi esperanton komprenas | je comprends franšais | entiendo espa˝ol | t˘i Ýt hiểu tiếng Việt | ich verstehe ein bisschen Deutsch | beware XHTML | common coding mistakes | tutorials | various stuff | argh PHP!

  3. #3
    Join Date
    Apr 2007
    Posts
    23
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Default

    Quote Originally Posted by Twey View Post
    Stay away from MSSQL. It's really not nice -- this should never happen, for a start. The most recent update should take precedence. You may be able to work around this problem (I'm tempted to call it a bug, but it's probably a feature), or at least reduce the likelihood of it happening, by performing a transaction like the PostgreSQL
    Code:
    BEGIN;
     ...
    COMMIT;
    Thanks Twey Bro.... Can we use oracle insted of sql..but is oracle more stable than sql ????

  4. #4
    Join Date
    Jun 2005
    Location
    英国
    Posts
    11,876
    Thanks
    1
    Thanked 180 Times in 172 Posts
    Blog Entries
    2

    Default

    Can we use oracle insted of sql..but is oracle more stable than sql ????
    Oracle's fairly decent, certainly better than MSSQL. I suggest PostgreSQL or, at a stretch, MySQL.
    Twey | I understand English | 日本語が分かります | mi jimpe fi le jbobau | mi esperanton komprenas | je comprends franšais | entiendo espa˝ol | t˘i Ýt hiểu tiếng Việt | ich verstehe ein bisschen Deutsch | beware XHTML | common coding mistakes | tutorials | various stuff | argh PHP!

  5. #5
    Join Date
    Apr 2007
    Posts
    23
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Default

    let me try that and will let you know the result....

Bookmarks

Posting Permissions

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