SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    if ($zee == "Guru") { $zee--;}
    Join Date
    Nov 2005
    Location
    Karachi - Pakistan
    Posts
    1,134
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQL for WEB - Concurrency

    Hi masters.

    I want to ask that if we have a website and people REGISTERED themselves there. There is a Table for REGISTRATION, say MEMBER.

    When a person registring him in the website and if the another person do it at the same time (as in the websites, millions of people visits the sites) then WILL IT BE A PROBLEM ? WILL I NEED TO HANDLE CONCURRENC ISSUE ? LIKE USING LOCKS ????? PLZ HELP

  2. #2
    SitePoint Wizard guelphdad's Avatar
    Join Date
    Oct 2003
    Location
    St. Catharines, ON Canada
    Posts
    1,707
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Use an auto increment column for an id number or something. Then it doesn't matter if the table is being accessed simultaneously, they won't both get assigned the same id number.

  3. #3
    if ($zee == "Guru") { $zee--;}
    Join Date
    Nov 2005
    Location
    Karachi - Pakistan
    Posts
    1,134
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    right, thanks .


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
  •