Sorting of data before query improves efficiency?

[Leo Leo]

Hi

I am storing large data into a table in Mysql from other source. However every time I append each monthly data to the table, the whole block gets appended below the table.

Example current table with the date as follows

20160330
20160229
..
20160201

Now, new monthly data is appended. Current table becomes

20160330
20160229
..
20160201

20160430
20160429
...
20160401

So you see the table is no longer in sequence with the date.

Also there would be chance when I load in an old block to current table. It would be appended to the bottom. Hence messing up the sequence in the table.

Do I need to sort them in orderly ie ascending order of dates and store them in the database so that next time I query, it will be faster ? If i do that, everything I load the data, I will have to sort them. It will be a very very large table.

Thanks