That can be a big problem when you are selecting/joining on these values with large tables. Further, you have several concat's which will slow down the query.
Type: Posts; User: copeg
Re: Mysql query performance issue in java batch
That can be a big problem when you are selecting/joining on these values with large tables. Further, you have several concat's which will slow down the query.
Re: Mysql query performance issue in java batch
Thread moved out of What's wrong with my code.
This is more of a SQL question than a java question. That being said you are doing a lot of operations within the query (Join, concat, etc...) with...