How to store shitload of small numbers in database most effectively? I am building school management system where teachers put students' grades and in big schools it would be a lot of it. Grade is a number from 1 to 6 so pretty small numbers. Would it be better to store it in some CSV file or still insert into database?
Excel sheet
>>55268430
paper
>>55268430
>How to store shitload of small numbers in database most effectively?
Don't use a database.
Use mongoDB
>>55268495
this mongoDB is "webscale"
>>55268430
Pretty sure your notion of "a shitload" wouldn't even tickle a decent database.
In Postgre you could use smallint (2 bytes) if integer or real if fractions are needed. You should never use a csv file if optimizing for performance.
>>55268508
ah yes. I say like around 50 000 per year. If I think about websites like Facebook it really isn't a shitload
>>55268558
See, if your concern is about performance, searches on indexed fields are O(log n), so you will be the richest guy on earth before running into performance problems in your use case. Just design your database properly and don't listen to Mongoloid web devs