Jump to content

judda

Administrators
  • Posts

    354
  • Joined

  • Last visited

  • Days Won

    44

Posts posted by judda

  1. 16 hours ago, Hare said:

    Seconding what was said about indexing! I've had the same experience with having so many rows in a database table that eventually the features started slowing down, but as soon as I added some proper indexing, it turned lightning fast. 

    Indexing can do wonders for performance. 

    Yes - but they are not a silver bullet, and actually can cause performance issues as well.  For example, if you happen to have 10 indexes on a table, and you do a bulk update of data, the update will take longer because while it's updating the rows it also has to touch the indices.  Just something to keep in mind when adding them :)

     

  2. We are kicking off the new year with a highly targeted ad campaign to revive TGL by acquiring new customers and sellers within the gaming community. This campaign is vital to ensure browser game owners and freelancers alike have access to an active community within a very niche category. 

    We have selected FurAffinity as our primary advertising outlet with the intention to run an Adwords campaign at the conclusion of the FA ads depending on performance. To make this happen, we are asking game owners, artists, developers, and loyal pet game players to support this endeavour by donating to our fundraiser via PayPal. 

    Help us reach our goal of $450!

    How the $450 will be spent

    We will be purchasing a 6-month package which includes 3 ad sizes (300x90, 300x200, and 728x90). FA serves ads to 1.1 billion customers each month, so we expect quite a few new faces to pop up once the ads are activated. 

    Any additional funds will be put towards the forum licensing, and an Google Adwords campaign at the conclusion of the FA ad run. 

    Thank you all for your continued support and dedication to the gaming community!

    • Like 5
  3. On 1/31/2021 at 10:45 AM, Kesstryl said:

    I don't see myself going back to VPL.  It's hard to trust that it won't go down again.  I'm also not a fan of what Silver-Brick went through (I'm a Mysidia Adoptables forum member and saw what was posted there), taking advantage of a kid like that.  I'm grateful to the leader and mods here for keeping the community together and will stick by this one. 

    Super unfortunate and annoying what he did with Silverbrick.

  4. As @crotanite said, don't fear "filling up the database", it's meant for storing and retrieving data quickly.  I was doing some recent work for @Vix and on my local computer, their admin panel for "inventory" would time out on my computer after 30+ seconds of running.  I then made a single index and it came back instantly.  There is so much you can do with it.

    I've had to deal with millions+ rows per day in a database (with weekly/daily reporting [think point of sale data]) so feel free to ask any performance related questions! I love to help!

    • Like 2
  5. Are the stats static (i.e. you will only have a max of 5-10 different ones)?

    CREATE TABLE pets
    (
      `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT , 
      `user_id` BIGINT UNSIGNED NOT NULL , 
      `species_id` INT UNSIGNED NOT NULL , 
      `name` VARCHAR(50) NOT NULL ,
      `strength` INT UNSIGNED NOT NULL , 
      `intelligence` INT UNSIGNED NOT NULL 
    )

    Something like the above should be sufficient.

    If there are going to be more dynamic ones (or ones that only take place in certain situations), then you may want to make a 1:many table but I won't go there for now because this will provide your most value.

    • Like 1
  6. I think I can remember one programmer that did this a while ago.  Unfortunately recently they have be found out to be a bit of a fraud, overselling and under-delivering.

    I like the idea of it a bit, but would never do this sort of trade myself just because it feels like it undercuts both parties.

    As @Hare mentioned, some will take it on and then fall through, so overall not worth it for you IMO.

  7. I know that this is a little less relevant to game sites, because of most of us source freelancers from all around the world, but how do you think the pandemic will change the workforce as a whole?

    I've been working remotely since March 13th with my meetup also going remote around mid-May.  I have always enjoyed working from home, so that transition for me wasn't really a hard one.  The biggest issue was getting my team to collaborate on new development which was a challenge given the limits of video conferencing.

    I have had several recruiters contact me over the last few months saying that "I'm the perfect fit for the role" (for both new and older companies), and say it's for an office once the pandemic is over.

    For me, I feel like I never want to step into an office again for work. 

    I know that a few companies have decided they will change their policy to working in the office is optional.  Do you think this will be a mainstream change overall?

  8. On 12/3/2020 at 12:09 PM, P3Games said:

    P3Games, a wild cat breeding sim is looking for artists. We have a need for all types of art and people who can help with several necessary art projects. 

    Person must work in digital art, be able to work with a team and be willing to work within our structure.  If you are interested please email to [email protected] and I'd be happy to go over details and what exactly we are looking for. 

    Thank you. Hope to hear from anyone interested. 

     

    Alex

    Alex is super friendly, and great to work with :)

    • Like 1
×
×
  • Create New...