Thread: Getting server host-ready

Page 4 of 6 FirstFirst ... 23456 LastLast
Results 31 to 40 of 59
  1. #31  
    Left to be damned

    Join Date
    Nov 2014
    Age
    27
    Posts
    119
    Thanks given
    28
    Thanks received
    6
    Rep Power
    26
    Quote Originally Posted by Scu11 View Post
    nobody mentioned anything about any sort of scheduled tasks. are you even reading my posts??
    I'm not going to do it by the end of a player session either. Again, it'll end up in data loss, if the server should crash at some point, which would be highly unlikely, but this can happen.

    Also!
    No need for the "on the fly" querying.
    It'll all be stored as follows:
    Player
    > PlayerDetails
    > PlayerSettings
    > PlayerBank
    etc. so;

    player.getDetails().getClanId()
    player.getUsername()
    Reply With Quote  
     

  2. #32  
    Getting server host-ready



    Scu11's Avatar
    Join Date
    Aug 2007
    Age
    30
    Posts
    16,307
    Thanks given
    7,215
    Thanks received
    12,308
    Rep Power
    5000
    Quote Originally Posted by conflickd View Post
    I'm not going to do it by the end of a player session either. Again, it'll end up in data loss, if the server should crash at some point, which would be highly unlikely, but this can happen.
    so you're seriously going to insert into the database every time a player does something like deposit an item into their bank?

    i hope you don't tell any of your players because they are going to just completely destroy your server by over-saturating your database connection by just repeatedly depositing and withdrawing shit

    Attached image
    Reply With Quote  
     

  3. Thankful users:


  4. #33  
    🎶 As you're falling down 🎶


    uint32_t's Avatar
    Join Date
    Feb 2015
    Posts
    1,396
    Thanks given
    6,177
    Thanks received
    776
    Rep Power
    5000
    Quote Originally Posted by conflickd View Post
    Not happening, it'll slow down my inserts, updates and replaces. Doing this wouldn't be beneficial at all.

    I COULD JUST MAKE EVERYTHING ONE BIG TABLE, OR KEEP LOADING FROM JSON!! GR8 IDEA
    Why would it slow it down? Scu is right, less joins is going to result in better performance.
    Quote Originally Posted by Idiot Bird View Post
    Quote Originally Posted by Velocity View Post
    lol np mate looks like the community brought ur rep down to ur IQ
    Not too sure about that, it's at 0 . It would have to go minus to even be remotely close to his IQ.
    Reply With Quote  
     

  5. #34  
    Left to be damned

    Join Date
    Nov 2014
    Age
    27
    Posts
    119
    Thanks given
    28
    Thanks received
    6
    Rep Power
    26
    Quote Originally Posted by Scu11 View Post
    so you're seriously going to insert into the database every time a player does something like deposit an item into their bank?

    i hope you don't tell any of your players because they are going to just completely destroy your server by over-saturating your database connection by just repeatedly depositing and withdrawing shit
    Yeah, regarding this I may have to re-think my strategies. However, I'm not really a fan of caching a withdrawal or deposit (for example) for more than 10 minutes, or until the bank session has ended (closed interface).
    You gave me stuff to think about, tyvm

    Quote Originally Posted by i_pk_pjers_i View Post
    Why would it slow it down? Scu is right, less joins is going to result in better performance.
    Depends on the setup, I'm not going to bother merging 28+ fields into one table, life's too short.
    Using FKs will speed up the query, however
    Reply With Quote  
     

  6. #35  
    WhiteDownMb | HYBRID JEFE
    Brett the Don's Avatar
    Join Date
    Dec 2009
    Posts
    2,117
    Thanks given
    349
    Thanks received
    556
    Rep Power
    2540
    Quote Originally Posted by conflickd View Post
    Yeah, regarding this I may have to re-think my strategies. However, I'm not really a fan of caching a withdrawal or deposit (for example) for more than 10 minutes, or until the bank session has ended (closed interface).
    You gave me stuff to think about, tyvm



    Depends on the setup, I'm not going to bother merging 28+ fields into one tables, life's too short.
    Using FKs will speed up the query, however
    Took you this long to come to that conclusion... and arguing...

    All of humanity's problems stem from man's
    inability to sit quietly in a room by himself




    Reply With Quote  
     

  7. #36  
    Left to be damned

    Join Date
    Nov 2014
    Age
    27
    Posts
    119
    Thanks given
    28
    Thanks received
    6
    Rep Power
    26
    Quote Originally Posted by Brett the Don View Post
    Took you this long to come to that conclusion... and arguing...
    that's never been the discussion
    Reply With Quote  
     

  8. #37  
    WhiteDownMb | HYBRID JEFE
    Brett the Don's Avatar
    Join Date
    Dec 2009
    Posts
    2,117
    Thanks given
    349
    Thanks received
    556
    Rep Power
    2540
    Quote Originally Posted by conflickd View Post
    that's never been the discussion
    Wish I could neg u.

    All of humanity's problems stem from man's
    inability to sit quietly in a room by himself




    Reply With Quote  
     

  9. #38  
    Left to be damned

    Join Date
    Nov 2014
    Age
    27
    Posts
    119
    Thanks given
    28
    Thanks received
    6
    Rep Power
    26
    Quote Originally Posted by Brett the Don View Post
    Wish I could neg u.
    be me guest, it was never the discussion whether or not I should query every action
    me made a good point when mentioned, and I took his advice.

    Quote Originally Posted by Scu11 View Post
    i just told you why, and a big table isn't necessarily hard to manage.
    you never really answered whether I should merge the 28+ fields from details and statistics alone, into the players table?
    Reply With Quote  
     

  10. #39  
    Getting server host-ready



    Scu11's Avatar
    Join Date
    Aug 2007
    Age
    30
    Posts
    16,307
    Thanks given
    7,215
    Thanks received
    12,308
    Rep Power
    5000
    Quote Originally Posted by conflickd View Post
    you never really answered whether I should merge the 28+ fields from details and statistics alone, into the players table?
    i did, i told you details and statistics can both be normalised into the players table (along with the other tables i listed) - because you only need the fields in those two tables when you're already querying for the player (i.e. on player save and player load)

    Attached image
    Reply With Quote  
     

  11. #40  
    Left to be damned

    Join Date
    Nov 2014
    Age
    27
    Posts
    119
    Thanks given
    28
    Thanks received
    6
    Rep Power
    26
    Quote Originally Posted by Scu11 View Post
    i did, i told you details and statistics can both be normalised into the players table (along with the other tables i listed) - because you only need the fields in those two tables when you're already querying for the player (i.e. on player save and player load)
    more fields has been added into both details and statistics, totaling in 42 fields - so you want me to add 42 fields to one table?
    Reply With Quote  
     

Page 4 of 6 FirstFirst ... 23456 LastLast

Thread Information
Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


User Tag List

Similar Threads

  1. Replies: 20
    Last Post: 07-07-2015, 07:15 AM
  2. Replies: 10
    Last Post: 06-03-2015, 11:43 PM
  3. Replies: 2
    Last Post: 05-28-2015, 11:34 PM
  4. Buying a Host Ready 474 Server & Client
    By JAVA GURU #1023 in forum Buying
    Replies: 4
    Last Post: 02-24-2012, 11:28 AM
  5. Replies: 15
    Last Post: 06-21-2009, 02:27 PM
Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •