+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24)
+--- Thread: Best idea for save many location (/showthread.php?tid=72038)
Best idea for save many location - omid_student - 10-28-2018
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?