Ah so you don't actually have 1000 (or whatever) schemas set up right off the bat?
Or I might be misunderstanding, and you're saying that you're just mapping which physical server has the schemas
Or I might be misunderstanding, and you're saying that you're just mapping which physical server has the schemas
user_id % 1000 -> schema ID
schema ID -> database ID
then select FROM schemaID.tablename etc on that particular database.The schemas are definitely a neat way to handle this though so you dont have to worry about table names.