We explored multiple performance issues that we might run into, and the solution required to tackle those issues. We started with the tracking behavior of EF Core, its projection behavior, and then we explored detecting change issues with bulk insert/updates and how to handle them. We enhanced the application by supporting asynchronous operations that allow us to handle threads effectively. Then, we analyzed/fixed the data that was retrieved and transmitted over the network, right from volume and columns, up until the number of database calls made to the data store. Finally, we saw how the datatype mismatch affected us, also how the missing indexes affected our retrieval performance, and the way to improvise in those scenarios.
Let's discuss the authentication implementation required, and then row-level security, and...
