10-28-2018, 04:44 AM
Hi
In my project exist 1000 users
Each user have many device and this device have many location for each day
I use partition for each device and save locations in that
But there are big problem
Maybe each partition have 1 million record
My idea is make table (for locations) for each user and add partition for each table
Does anybody have any idea for it?
In my project exist 1000 users
Each user have many device and this device have many location for each day
I use partition for each device and save locations in that
But there are big problem
Maybe each partition have 1 million record
My idea is make table (for locations) for each user and add partition for each table
Does anybody have any idea for it?