Thread: Getting server host-ready

Page 5 of 6 FirstFirst ... 3456 LastLast
Results 41 to 50 of 59
  1. #41  
    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
    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?
    are u going to repeatedly keep asking me the same question?

    you realise you have to query those fields in irrespective of them being in the same table anyway, right? denormalising them avoids the table joins.

    Attached image
    Reply With Quote  
     

  2. Thankful users:


  3. #42  
    Left to be damned

    Join Date
    Nov 2014
    Age
    27
    Posts
    119
    Thanks given
    28
    Thanks received
    6
    Rep Power
    26
    I’m honestly asking, because 42+ fields in the same table and you’re not calling bad practice?.?.?.?.? so much for professional level dev
    Reply With Quote  
     

  4. #43  


    Omar's Avatar
    Join Date
    Dec 2007
    Posts
    279
    Thanks given
    640
    Thanks received
    783
    Rep Power
    5000
    Quote Originally Posted by conflickd View Post
    I’m honestly asking, because 42+ fields in the same table and you’re not calling bad practice?.?.?.?.? so much for professional level dev
    why do you need them in separate tables
    Attached image
    Reply With Quote  
     

  5. Thankful users:


  6. #44  
    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 arseny View Post
    why do you need them in separate tables
    to not have a massive table :
    Reply With Quote  
     

  7. #45  
    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 honestly asking, because 42+ fields in the same table and you’re not calling bad practice?.?.?.?.?
    you still clearly do not understand that you are normalising them for the sake of normalisation. stop and think for one second about the queries you are writing: player save, player load.

    in both of these queries you end up inserting/selecting all of the fields from all of these tables. that means each time a player is loaded you're joining on these 5 tables, and each time a player is saved you're writing 5 separate insert statements.

    by denormalising, you would avoid all of the joins and consolidate the inserts into a single insert statement.


    Quote Originally Posted by conflickd View Post
    so much for professional level dev
    i have close to 5 years experience as a professional software developer, u?


    Quote Originally Posted by conflickd View Post
    to not have a massive table :
    can you actually explain why you think massive tables are bad? what performance gain are you getting out of splitting them? you certainly aren't improving the amount of storage space it takes to store the data.

    Attached image
    Reply With Quote  
     

  8. Thankful users:


  9. #46  


    Omar's Avatar
    Join Date
    Dec 2007
    Posts
    279
    Thanks given
    640
    Thanks received
    783
    Rep Power
    5000
    Quote Originally Posted by conflickd View Post
    to not have a massive table :
    so, you're questioning people's judgement and DBA ability while your sole reason in this schema design is "I don't like looking at it"?
    Attached image
    Reply With Quote  
     

  10. Thankful users:


  11. #47  
    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
    you still clearly do not understand that you are normalising them for the sake of normalisation. stop and think for one second about the queries you are writing: player save, player load.

    in both of these queries you end up inserting/selecting all of the fields from all of these tables. that means each time a player is loaded you're joining on these 5 tables, and each time a player is saved you're writing 5 separate insert statements.

    by denormalising, you would avoid all of the joins and consolidate the inserts into a single insert statement.



    i have close to 5 years experience as a professional software developer, u?
    7 years ranging from java to c

    who gives an honest fuck about saving/loading, as long as you're doing things on the fly?
    Reply With Quote  
     

  12. #48  


    Omar's Avatar
    Join Date
    Dec 2007
    Posts
    279
    Thanks given
    640
    Thanks received
    783
    Rep Power
    5000
    Quote Originally Posted by conflickd View Post
    7 years ranging from java to c
    literally the intro to database design class here tells you exactly the same things scu11 has posted multiple times throughout the thread (i.e. don't do exactly what you're doing - normalizing just to do it, designing your schema before thinking about your data and how you want to query it)

    I don't know how you've made it 7 years in industry without knowing these things that you'd pick up 1st year CS, all while acting incredibly arrogant about it

    it's one thing to be wrong; that's fine, everybody is, and often, but it's another to plug your ears and keep repeating the same shit while acting like everyone else trying to help you is an idiot
    Attached image
    Reply With Quote  
     


  13. #49  
    Est. RS2005/PS2007

    Pertinax's Avatar
    Join Date
    Jan 2015
    Age
    28
    Posts
    145
    Thanks given
    235
    Thanks received
    76
    Rep Power
    986
    Quote Originally Posted by arseny View Post
    it's one thing to be wrong; that's fine, everybody is, and often, but it's another to plug your ears and keep repeating the same shit while acting like everyone else trying to help you is an idiot
    Hey man, be careful to not pop his inflated ego. Easier, for him, to continue on a trail of denial and deflection than it is to admit fault: He'd rather be right, even if it means being wrong.
    There's no point in continuing a discussion with someone who's arguing solely for the sake of being right.
    Spoiler for ScapeRune's definition of success:
    Attached image
    Quote Originally Posted by Kool aid boy View Post
    I went on to give it a try but i saw it was dead af so i left. Is there ever peak time?

    Says like 7.5k accs registered on forums but only 2 people on?


    Reply With Quote  
     

  14. #50  
    Developer


    Join Date
    Oct 2013
    Age
    29
    Posts
    1,038
    Thanks given
    689
    Thanks received
    321
    Rep Power
    260
    The arrogance is real here. He's literally offering constructive criticism and you're going to insanely stupid lengths to try and prove him wrong when you are clearly in the wrong. How do you plan to run a decent server with this attitude?

    Attached image
    Spoiler for vouches(20+):

    Reply With Quote  
     

  15. Thankful user:


Page 5 of 6 FirstFirst ... 3456 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
  •