Search Unity

Resolved Tables performance question

Discussion in 'Localization Tools' started by Goty-Metal, Mar 20, 2021.

  1. Goty-Metal

    Goty-Metal

    Joined:
    Apr 4, 2020
    Posts:
    168
    Hi there!, i'm wondering if it's better to have less tables with more entries or more tables with less entries, in other words, what would be better:

    Table #1: entry#1, entry#2, entry#3
    Table #2: entry#1, entry#2, entry#3
    Table #3: entry#1, entry#2, entry#3

    OR

    Table #1: entry #1, entry #2, entry #3, entry #4, entry #5, entry #6, entry #7, entry #8, entry #9

    I'm starting to have soo many tables because usability+readability but i don't want to crush performance, so i could merge some of them.
    Logic tells me = less tables = better.

    But i'd like to know your opinion.

    Thanks!
     
    Goty-Metal, Mar 20, 2021
    #1

  2. karl_jones

    karl_jones

    Unity Technologies

    Joined:
    May 5, 2015
    Posts:
    8,288
    I can't see there being a noticeable difference. It really depends how you are getting the entries. In theory having a single table would mean we only need to load one but once it's loaded then there's not much difference between having 1 and 100. We use a dictionary lookup for the table and then the entry which should be fine for a large number of entries. Memory wise each table has an overhead (150~ bytes I think) due to it being a scriptable object but this is tiny compared to everything else in a game.
    So I would say go with whatever is easiest to organise and manage rather than what you think will give better performance. As always try the profiler and see for yourself if there's any real difference.
     
    karl_jones, Mar 20, 2021
    #2
    Goty-Metal likes this.

  3. Goty-Metal

    Goty-Metal

    Joined:
    Apr 4, 2020
    Posts:
    168
    I see, the truth is that in general the game loads pretty fast, i'm curently preloading all tables in the game start to make sure they're ready to go anywhere, most LocalizedStrings are assigned to the scripts via inspector to avoid typos in the code, so thanks for the reply!
    You do a great work like always, enjoy your weekend boss!:D
     
    Goty-Metal, Mar 20, 2021
    #3
    karl_jones likes this.

  4. emadkh

    emadkh

    Joined:
    Aug 23, 2013
    Posts:
    21
    Based on my experience, when the there are too many entries on a single table, localization table window will be having a hard time rendering and opening.
    as an example, i had this 8000 localization entry in single table and it took about 15 mintutes to open the window.
    so I guess it depends on the number of entries.
     
    emadkh, Apr 27, 2021
    #4
    Goty-Metal likes this.

  5. Goty-Metal

    Goty-Metal

    Joined:
    Apr 4, 2020
    Posts:
    168
    Wow no i'm having like 50 max per table, i'm better splitting everything into more categories, but i'm not making any game with too much dialog that's true.
     
    Goty-Metal, Apr 27, 2021
    #5

  6. karl_jones

    karl_jones

    Unity Technologies

    Joined:
    May 5, 2015
    Posts:
    8,288
    Hi this is a known issue. We have plans to improve the table editor performance.
    Are you able to file a bug report? It would be good to have a real example to compare against.
     
    karl_jones, Apr 27, 2021
    #6