datagod's Feed

datagod
10-04-2019 at 01:05 PM
10 Comments
Rate this Entry

Twin Galaxies Malfunction!!

Hello @admin staff @SincerelyFranny @JaceHallI

I attempted to open a dispute on an Atari 2600 Commando score by Rudy Ferretti, and I clicked on the "undisputed" link, but it opened the dispute for somebody else.

https://www.twingalaxies.com/showthread.php/210507-Dispute-WILLIAM-MCEVOY-Atari-2600-VCS-Commando-NTSC-Game-1-(Points)-Player-Alan-Hewston-Score-274-700?p=1057583&posted=1#post1057583

Can you please change this so that Alan Hewston is removed, and Rudy is added?

Thanks.

Comments
  1. datagod's Avatar


    Miss Franny please help me. I tried to open a dispute against Rudy Ferretti's score of 1,000,000 points on Atari 2600 Commando, and it instead went to another player. I did not notice the name change until I hit submit. Now I cannot submit another dispute for 24 hours. :(

    ThanksSincerelyFranny thanked this post
  2. datagod's Avatar

    Mrs. Franny, you can see here that Rudy does indeed have a dispute, but the link is broken.

    https://www.twingalaxies.com/game/commando/atari-2600-vcs/ntsc-game-1-points/page/1?ref=fbshare


    So the system did indeed know that I clicked on Rudy. Perhaps because he has been banned for 4000+ years something went wrong during the dispute creation process?

  3. Riatoju's Avatar

    Maybe Jace Hallll can help out. You know his zombie, mentally deficient brother who holds down the L button when typing his last name.

    Likesdatagod liked this post
  4. datagod's Avatar

    I should make a video of how long it takes for the tagging system to work on my PC. I am surprised I only typed on extra L

    [MENTION=44024]Riatoju[/MENTION] <-- That took 9 seconds to populate

    Something weird is happening in the browser on this website. Text is very slow to enter, eventually gets caught up. Almost as if multiple javascripts are fighting over the text entry in order to see what info they can give to advertisers.

    :(

    Likesthegamer1185, Riatoju liked this post
  5. thegamer1185's Avatar

    Dude, I have given up on tagging people. Half the time it doesn't pop up, 1/4 I enter the same keys over and over because I'm assuming the input just isn't working and then it finally does with 15 attempts of me typing the same thing over and over, and the other 1/4 it completely fucks up my text and the whole message is all garbled or gets deleted.

    Likesdatagod liked this post
  6. Snowflake's Avatar

    kyle, when you say it garbles the text is that from tagging one person or two? i've only experienced that bug when tagging more than one person. by limiting myself to one tag per post, yes i still have the awful lag datagod mentions, but i at least avoid the bug you mention

  7. Riatoju's Avatar

    Quote Originally Posted by datagod

    I should make a video of how long it takes for the tagging system to work on my PC. I am surprised I only typed on extra L

    @Riatoju <-- That took 9 seconds to populate

    Something weird is happening in the browser on this website. Text is very slow to enter, eventually gets caught up. Almost as if multiple javascripts are fighting over the text entry in order to see what info they can give to advertisers.

    :(


    They are likely using a combination of JavaScript and some server side script to populate the tagging system and querying the user registration database rather than using a cached database of all the users.


    Scripts like Python, PHP aren't designed for Facebook like systems that handle notifications, populate news feeds ect...you need actual servers for that, they'd have better luck with node.js or actual server software designed to handle these tasks.

    The database queries are likely overly complex too, for example enigmaV my prototype system suffers from complex database queries like fetching posts, doing a sort of sub queries to fetch user profiles for each post and fetching post categories all in one query. In retrospect it's poor design. I could have cached the entire post with all that info already in it, and if the user ever changed their info do a system wide queue that updates every single post gradually in the cache...that's how Facebook does it...I actually seen their caching system fall behind once, and had old info like a name change not get updated until days later...


    Twingalaxies suffers from complex queries and lacks caching. It's like 2012 me built this site.

    Likesdatagod liked this post
  8. thegamer1185's Avatar

    Quote Originally Posted by Snowflake

    kyle, when you say it garbles the text is that from tagging one person or two? i've only experienced that bug when tagging more than one person. by limiting myself to one tag per post, yes i still have the awful lag datagod mentions, but i at least avoid the bug you mention

    Good call, I believe it was two people back to back. To avoid it I would tag someone, type lksjf (literally) and then tag the other person. Seems there needs to be text in between each tag to not screw it up.

    ThanksSnowflake thanked this post
    Likesdatagod liked this post
  9. datagod's Avatar

    I have seen some pretty horrible database designs. One client of mine was complaining that their main portal page was timing out. The portal had a section for "you have X new messages". The problem was the way the developers implementing messages being read. The updated the email itself (stored in a table) to have the subject include "READ" as part of the subject line, instead of having a simple indicator column (0/1) that could store the same info.

    Every morning 2500 employees would fire up their desktops, the portal would load, and the system would bog down with all these queries trying to find out how many email subjects didn't have the word READ in them.

    I would love to spend a few days behind the scenes at Twin Galaxies, tuning the qeuries and optimizing their layout.

    Another frustrating element is the notifications. You have a list that shows 10 notifications, you click the first one then they are all reset. You can't then go back and read the other 9 without hitting the "show all notifications" function which times out half the time.


  10. Marcade's Avatar

    Quote Originally Posted by datagod

    I have seen some pretty horrible database designs. One client of mine was complaining that their main portal page was timing out. The portal had a section for "you have X new messages". The problem was the way the developers implementing messages being read. The updated the email itself (stored in a table) to have the subject include "READ" as part of the subject line, instead of having a simple indicator column (0/1) that could store the same info.

    Every morning 2500 employees would fire up their desktops, the portal would load, and the system would bog down with all these queries trying to find out how many email subjects didn't have the word READ in them.

    I would love to spend a few days behind the scenes at Twin Galaxies, tuning the qeuries and optimizing their layout.

    Another frustrating element is the notifications. You have a list that shows 10 notifications, you click the first one then they are all reset. You can't then go back and read the other 9 without hitting the "show all notifications" function which times out half the time.



Join us