1、减少和数据库交互（将所需要的信息放入内存）。2、减少装箱拆箱操作。3、类型比较用CompareTodecimal agemin = diseasemodel.AGE_MIN.CompareTo(0M)==0 ? 18 : diseasemodel.AGE_MIN;sql查询速度优化可以加索引，单个索引联合索引。...

ORA-01480: trailing null missing from STR bind value今天用PL/SQL Developer往一个字段（VARCHAR(3000)）里更新值时出错，报“ORA-01480: STR 赋值变量缺少空后缀”，查了一下英文定义为：ORA-01480: trailing null missing from STR bind valueA bind variable of type 5 (null-terminated string) does no..