dvd420 Posted February 21, 2011 Share Posted February 21, 2011 Hi, I am making application for vehicle tracking system using GPS. There I am supposed to receive data every minute from a device. Technically - I will be getting 5 records every minute per device. i.e 5 * 60 * 24 records/day = 7200 records/day for single device. I am suppose to store that data for 2 months i.e 7200 * 30 * 2 = 4,32,000 records for a single device. If number of devices are 100 then storing all the records (43200000 records) in single table wont be a feasible option, as i need to fetch records from the table for report generation. Can any one help to come over the above mentioned problem? Thanks, Rahul Quote Link to comment https://forums.phpfreaks.com/topic/228411-db-architecture/ Share on other sites More sharing options...
Muddy_Funster Posted February 22, 2011 Share Posted February 22, 2011 My suggestion would be to create -at the least- a different table for each device every month. I am, however, a little concerned that you may be out your deapth with this if your imediate thinking was to store everything in a single table (that, and you put the comma in the wrong place for 432,000 ). Quote Link to comment https://forums.phpfreaks.com/topic/228411-db-architecture/#findComment-1178117 Share on other sites More sharing options...
dvd420 Posted February 22, 2011 Author Share Posted February 22, 2011 Well current view is precisely to make different table for different device. That is surely better then storing the data under the single table. Second is to apply partition to database. But I am looking for more specific and more tricky solution. More inputs are most welcome. Quote Link to comment https://forums.phpfreaks.com/topic/228411-db-architecture/#findComment-1178276 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.