Sphinx, how to create a config if the number of tables can change but they are of the same type?

Question

MySQL

There is a mysql database that contains tables of the form client_ID where ID is a numeric value corresponding to the client ID, i.e. client_1, client_123, etc.
The structure of the tables is naturally the same, but the number of tables themselves can change over time, i.e. some are deleted, others are created...
Whether I'm wondering if it's possible to somehow make Sphinx work if the number of tables changes? And if possible, how? At least something to read?
As an option - you can advise something else that can be used. The task is to search by type like %test%, i.e. searching from both sides...

Answer 1

Make one customer table. If volumes of billions of rows require it, partition using regular means.

Answer 2

The right thing to do is never do that. What problem are you solving? It is very difficult to advise architecture and "how it can be done" without setting it up. The deletion problem can be solved by setting the "isActive" or "isDeleted" flags.

Answer 3

just generate sphinx config each time