[GitHub] [shardingsphere] liuheng1104 commented on issue #24257: How can we solve a large number of queries that contain in, if the parameter after in is large

["liuheng1104 (via GitHub)" <gi...@apache.org>]

liuheng1104 commented on issue #24257:
URL: https://github.com/apache/shardingsphere/issues/24257#issuecomment-1436629064

   Our business is divided into 256 tables. Use the partition key (user_Id) to query in. The parameters are 100, and the logical sql is select * from table where user_ Id in (100 parameters), actual sql: select * from table_ 1 where user_ Id in (100 parameters), select * from table_ 2 where user_ Id in (100 parameters),
   
   Many parameters after in are invalid code scanning
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org