PHP+mysql member and consumption record table big data connection query, how to solve it, urgently looking for a solution

Question

1. Membership table: There are fields such as membership card number, name, phone number, gender, points, etc. (tens of millions of data)
2. Consumption record table: associated field membership card number (tens of millions of data, divided into tables, divided according to consumption time)

The following are search conditions. Now you need to find the corresponding member list according to the search conditions (the total number needs to be counted)

For example: query all members whose age is 46-60 years old, gender: female, whose points are between 100-200, who have consumed twice in the past 90 days and the consumption amount is 100-200 yuan, and count the total number.

PHP+mysql member and consumption record table big data connection query, how to solve it, urgently looking for a solution

reply all(0)I'll reply