I'm searching for the best node.js framework for GPS tracking project where locations will be displayed real time on google maps. So far it was made with node+angular+express+socket.io but we are facing huge loads to the sockets where it starts communicate with postgre (over 300,000,000 records on the database to use selects/updates). So at this moment I'm looking for best MVC based framework for real time locating and displaying for users.
So far I have only two favorites - Sails.js and Meteor but which one should I chose? Which one have the better documentation and which one would be better to use for high load and high traffics? Which one could get easier implemented with angular and maybe there are framework based only for that what I need? Thanks!
The problem I'm facing:
when more then 1000 people starts to track their location on maps, sockets starts to lag - when it sends the request to the app it makes request to another server via redis and receive location. Then it sends the location to user and thats how the user receives the callback of sent socket emit. After that (or the same moment) the app starts to update details on database for user and his location. I'm using transactions for this but I'm facing the problem after user requests new location and server is still working to update his previous location. Thats how it lags and can't display his next location until the previous one will not be finished the work with database/arrays on ram (tmp arrays for all users).
As I've mentioned before the main table app is working with the table on database which have more then 300,000,000 records on it and this count is only temporary (cleaning older then 24 hours records - transfering it for data collecting). I'm using postgre to deal with connections and it seems that all queries are working perfectly and the only problem is that huge amount of data.
via Sandra
No comments:
Post a Comment