please find the table structure and it don't have indexed column.
Table : TB60_TMP_MESSSAGE_UPLOAD
Field Type Null Key Default Extra
TMP_TAG_PROJECT varchar(4) YES ...
Type: Posts; User: siva.wins
Re: Mysql query performance issue in java batch
please find the table structure and it don't have indexed column.
Table : TB60_TMP_MESSSAGE_UPLOAD
Field Type Null Key Default Extra
TMP_TAG_PROJECT varchar(4) YES ...
Mysql query performance issue in java batch
Hi,
We are having the java batch job, it will receive the around 250000 records and upload into the mysql database.
table TB10_MESSAGE having aroung 1 crore record and TB60_TMP_MESSAGE_UPLOAD...