What points can be altered to make position table more optimized.
My position table has 71 million rows
Size is 18.7 GB
my history setup is 365 days.
Please guide
how many devies you are running? You want to retrieve based on time?
just create partition for each device, then query would just run fine.
What points can be altered to make position table more optimized.
My position table has 71 million rows
Size is 18.7 GB
my history setup is 365 days.
Please guide