之前自己搭建的一个关于SSH(spring+springMVC+hibernate3)的框架,但是存在不完整的地方,项目在上线运行过程中存在访问速度慢的,时常存在页面卡顿的情况。
导致页面反应慢的原因:
1.项目框架搭建不够好;
2.数据库访问缓慢(安装在阿里云的mysql数据库所在服务器内存不够,直接使用navicat查询,也会存在卡顿)
项目优化:
1.hibernate 添加连接池配置
上一篇记录application.xml文件关于hibernate配置 替换为
<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource" ref="dataSource"></property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">com.MySQLExtendDialect</prop>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.format_sql">true</prop>
<prop key="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider</prop>
<prop key="hibernate.cache.use_second_level_cache">true</prop>
<prop key="hibernate.cache.use_query_cache">true</prop>
<prop key="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</prop>
<prop key="initialPoolSize">30</prop>
<prop key="hibernate.c3p0.max_size">60</prop>
<prop key="hibernate.c3p0.min_size">10</prop>
<prop key="hibernate.c3p0.timeout">120</prop>
<prop key="hibernate.c3p0.max_statements">100</prop>
<prop key="hibernate.c3p0.idle_test_period">120</prop>
<prop key="hibernate.c3p0.acquire_increment">2</prop>
<prop key="acquireIncrement">3</prop>
<prop key="acquireRetryAttempts">30</prop>
</props>
</property>
<property name="mappingDirectoryLocations">
<value>classpath:mapper/</value>
</property>
</bean>