Ontropy
DTDrizzle Team
•Created by MrMendez on 9/11/2023 in #help
dynamic table name
hey, i was facing a similar issue. i am working on a multiplayer game, which has rooms, so a certain amount of players in a particular room can only interact with each other.
now each room will be storing some coordinates and data, which could go up to be in a few 100 thousands.
initially i had been putting in all the data in one huge table, and separating using room name while querying.
to eliminate the separation part each time for such a huge database, i was thinking i could make tables for each of the rooms on the fly.
sort of like
CREATE TABLE ${ roomName }
what would be the appropriate approach for this? if go with the single huge table approach, i fear the table would go into many millions in a month and the queries would start to slow.10 replies