Currently i'm storing my data in 4 diffrent file (that handle data from specified day,month,week,year). The day size of file is 1440 (that handle data which is send reads every minute and the date of reads is also stored per line) In this way if i for example need data from 1 May To 3 May i just download data from weekend file and filter downloaded records.
Is there any better way to fast accessing to files (or just download part of file or download splitted one file from specified files). I just thinking about u-sql executing beforce downloading but it take too long until u-sql end his job.