SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Enthusiast
    Join Date
    Jul 2009
    Posts
    54
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    scanning repeatedly.

    I am trying to make a multi-player game and I wanted to know whats the best way to go about this? The game will need to scan the database continually using a chron job I assume. It may also need to add or remove data based on what it receives. Basically I wanted to know is it a wise idea to set up a database scan for every tenth of a second? Will the computer even be able to process it that fast and modify information once the database reaches 100,000 members?

    Does anyone have any experience in this? Is there an article anyone can point me to which would help. I tried searching google but came up with nothing.

  2. #2
    From Italy with love silver trophybronze trophy
    guido2004's Avatar
    Join Date
    Sep 2004
    Posts
    9,501
    Mentioned
    163 Post(s)
    Tagged
    4 Thread(s)
    scan?

  3. #3
    SitePoint Enthusiast
    Join Date
    Jul 2009
    Posts
    54
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    yes as in run through every record.... scan the database... I basically need to know what everyone is doing at all times and since the base is database driven i need a way to read the entire database check if the person is logged on, if they are then read the information and display it client side to whomever that information applies to. So it will need to be scanned continually as soon as it reads all records then it will read it again and again and again etc....

  4. #4
    From Italy with love silver trophybronze trophy
    guido2004's Avatar
    Join Date
    Sep 2004
    Posts
    9,501
    Mentioned
    163 Post(s)
    Tagged
    4 Thread(s)
    When you need to show some info client side, you'll get that particular info from the database the moment you need it. You'll use queries for that.


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
  •