用ibatis提升一类数据库检索查询的性能

PERFORMANCE PROMOTION OF A KIND OF DATABASE RETRIEVAL WITH IBATIS

对SQLmap和O/Rmapping及其对应的工具作了简要的介绍。指出一类实际应用中O/Rmapping工具难以解决的问题:由于它的粗粒度,丧失了数据库操作应有的灵活性。给出相应的SQLmap解决方法:用两个类映射同一张表并且共用一个缓冲池。最后通过实际的性能比较,证明了此种解决方案的有效性。

Firstly,a brief introduction to SQLmap, O/Rmapping and their corresponding tools is made, and then the problem that the O/ Rmapping tools meet is pointed out, Because of the big granularity, the flexibility, which the database operation should have, is lost. The corresponding SQLmap solution is presented. Two different classes are used to map the same table,and a same cache is shared. Finally the validity of the solution is proved by the actual performance comparison.