When querying a database, the query becomes slower and slower as the data keeps increasing, is there any way to optimize it so that the query becomes faster?
Add fields to the database table to categorize the data, such as insertion time, data category, and strings containing any special text. Then you can take the categorized data and put it into other different tables so that you can turn big data into small data for querying. After that, adding indexes and adding partitions may be faster.