I have a general Klipfolio performance question. A client have several data sources, including a handful of csv files on a ftp server. Each file contain 100.000+ rows, and they have id's to link information together (just like a relational database). Data will only be refreshed once a day, but my concern is about interface performance. How will lookup, group, groupby, select and other formulas behave?
I don't have any experience working with such lage data set, and looking for some general advices and best practices. Dataset is within the 10mb limit (please increase....)