10 million dataset

I have a dataset of about 10 million records , which will change on daily basis. I am trying to build a mendix app based on this data, is it a good idea to put this data in mendix or should i actualy build it out separately and expose rest services which can be consumed by mendix ?  
1 answers

It all depends on the user experience and how much time it will take to import these records. If the user is willing to wait on the response of the REST service I would use that option. I saves the hassle of syncing the data. But if speed is of the essence I would sync the records during the off hours. But if the records are also large this still can take a lot of time.