![]() You have to analyze your schema structure, indexes, query joins, etc. Row size is one factor, but not the only one. Create the database in the PostgreSQL database server In this step, we are creating the database name as springbootjdbctemplate in the PostgreSQL database server. You need to also identify what is the real reason of slowness. Below is the step-by-step procedure to create the example of the spring boot JDBC template is as follows. Two common strategies are to query the first N pages, and store it on a temporary cache - or to query only enough to fill one page size (eg: 200 rows), and query the next 200 rows only if the user request it. You need to first decide what kind of paging strategy to use. Normally the size of a user-facing page is not more than 200 rows, hence querying 100-300K rows seem excessive and waste a lot of memory. However even if it does it might not help your code runs faster. I believe JdbcTemplate doesn't have specific feature for paging.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |