Services-Database-Experience

(1) Minimize the direct operation of the database.

(2) If the data synchronization, when the data volume is too large, by first querying the ID collection, and then through the ID can determine whether the local data exists, if not exist then the save operation exists update operation, this is the case of a table data volume is too large, It is not possible to synchronize all the segments at once.

(3) If it is a multi-table union query, try to return the result set you want with the SQL statement stitching method.

(4) When a field contains some fields such as blob or CLOB, we save the object directly through hibernate, we need to convert the blob to byte[]. Clob to a string as the database field value is saved by Prestatement.

Services-Database-Experience