Majority of developers have a strong feeling — what works faster at their environment will perform faster in production. No. Some teams, that are good in database development, are thinking like — why to make any logic at app server level, working intensively with data? If at database level I will even don’t have to pull data out from the server, end-result will, certainly, be achieved faster. It will. When a system works under moderate workload, it will work faster. Until database server will have excessive resources.
Don't optimize performance for the speed of execution, especially in the development environment!
Fast vs resource-saving is latency vs throughput moment, where majority choose latency without considering throughput. That’s how limitations are typically laid down in architecture, and eventually, it comes to light! Typically when a new type of workload introduced.