It seems that I have completed the mirroring and deployment tasks. However, I noticed that the query speed for the homepage and list pages was extremely slow. I was using the default PostgreSQL database. According to the suggestions from artificial intelligence, I adjusted some parameters and enabled/disabled certain options. The query time for the homepage was optimized from 15 seconds to 5 seconds. For the list page, it was shortened from several seconds to approximately 5 seconds. Next, artificial intelligence suggested that I create an index. It seems that perhaps more SQL tutorials should be published on GitHub. I may not be familiar with SQL.
I have 300,000 pieces of data. I hope to replace the current database with a more advanced one to speed up the processing of my media library.
It seems that I have completed the mirroring and deployment tasks. However, I noticed that the query speed for the homepage and list pages was extremely slow. I was using the default PostgreSQL database. According to the suggestions from artificial intelligence, I adjusted some parameters and enabled/disabled certain options. The query time for the homepage was optimized from 15 seconds to 5 seconds. For the list page, it was shortened from several seconds to approximately 5 seconds. Next, artificial intelligence suggested that I create an index. It seems that perhaps more SQL tutorials should be published on GitHub. I may not be familiar with SQL.
I have 300,000 pieces of data. I hope to replace the current database with a more advanced one to speed up the processing of my media library.