单表数据100万，查询慢，如何优化

zhangql8

单表数据100万，查询慢，如何优化。
已使用分页显示
Refresh data failed ！ ,
Java heap space
[url=]Hide Detail[/url]
java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at com.justep.system.action.Engine.invokeActions(Native Method) at com.justep.system.action.Engine.invokeActions(Unknown Source) at com.justep.business.server.BusinessServer.doAction(Unknown Source) at com.justep.business.server.BusinessServer.doExcute(Unknown Source) at com.justep.business.server.BusinessServer.excute(Unknown Source) at com.justep.business.server.BusinessServer.excute(Unknown Source) at com.justep.business.server.BusinessServerServlet.execService(Unknown Source) at com.justep.business.server.BusinessServerServlet.service(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:723) at com.justep.x.bs.BusinessServerServlet.service(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:723) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:745) Caused by: java.lang.OutOfMemoryError: Java heap space at com.mysql.jdbc.Buffer.<init>(Buffer.java:54) at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1972) at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:3285) at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:463) at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:3009) at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:2257) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2650) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2002) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source) at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source) at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source) at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source) at com.justep.system.data.BizData.query(Unknown Source) at BizProcedure.query(BizProcedure.java:12) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at com.justep.system.action.Engine.invokeActions(Native Method) at com.justep.system.action.Engine.invokeActions(Unknown Source) at com.justep.business.server.BusinessServer.doAction(Unknown Source) at com.justep.business.server.BusinessServer.doExcute(Unknown Source) at com.justep.business.server.BusinessServer.excute(Unknown Source) at com.justep.business.server.BusinessServer.excute(Unknown Source) at com.justep.business.server.BusinessServerServlet.execService(Unknown Source) at com.justep.business.server.BusinessServerServlet.service(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:723) at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)

jishuang

Java heap space是内存空间不够用了
http://docs.wex5.com/setup-wex5-jvm/

http://docs.wex5.com/bex5-deploy-question-list-10027/

zhangql8

jishuang 发表于 2017-11-1 13:52
Java heap space是内存空间不够用了
http://docs.wex5.com/setup-wex5-jvm/

改为数据库分页后显示时间有优化，但是还需50多秒，还有其他优化方式吗。查询条件如下：
fTUBE>1 AND fSAMPLESTATE LIKE '%已入库%'。实际查询到的数据只有7条。

jishuang

http://doc.wex5.com/wex5-deploy-question-list-1001/