Page 1 of 1

Splitting sites

PostPosted: Sun Mar 17, 2013 2:23 am
by dbabo
Hello,
apologies if this was asked already - can't seemed to locate the question.

the question implies my absence of any knowledge of the database schema used.
Q:
is it possible to separate users ( and all related information ) per site ? in other words _if_ all users and their stats are stored in one gigantic USERS table, would it be possible to split this table based on the site these users played on?

the DB size is relatively large (4GB) and i have information their for sites i haven't played for a while. So i think sooner or later i'll start getting performance issues...

Let me know
Thank you

Re: Splitting sites

PostPosted: Sun Mar 17, 2013 8:02 am
by kraada
Players and hands are stored in the same table but there is an id_site key value that lets the queries distinguish which site the player and hands were played on. We do not have any plans to automate splitting of the database like you describe but it should not cause significant issues at the sizes you are discussing unless your computer is very old (and even then only in reports where you're looking at all of your data).

highfalutin