视图打开缓慢，系统列表视图很快

woaiyingch

询问一下，在数据中心做得视图（超过2000条数据）加载要10秒以上，内容管理里面自带的系统列表就很快，几乎1秒加载，


自己做得视图有办法提高加载速度么？

论坛管理员

您的o2oa是什么版本？视图已经优化过的，不应该会出现缓慢的问题的

woaiyingch

论坛管理员 发表于 2023-4-18 13:28
您的o2oa是什么版本？视图已经优化过的，不应该会出现缓慢的问题的

7.2.7版本的 ，因为要用ldap用户的模块，所以没升级。

woaiyingch

论坛管理员 发表于 2023-4-18 13:28
您的o2oa是什么版本？视图已经优化过的，不应该会出现缓慢的问题的

而且，我打开视图的时候，命令行里会报下面的错误

2023-04-18 15:39:05.867 [ApplicationServerQueuedThreadPool-64] ERROR com.x.base.core.project.scripting.JsonScriptingExecutor - id:5f6cec35-4c1a-422c-bed9-7a5f84efdf8c, name:com.x.base.core.project.scripting.JsonScriptingExecutor, message:TypeError: Cannot read property "view" from undefined in <eval> at line number 2, exception:javax.script.ScriptException.
javax.script.ScriptException: TypeError: Cannot read property "view" from undefined in <eval> at line number 2
        at jdk.nashorn.api.scripting.NashornScriptEngine.throwAsScriptException(NashornScriptEngine.java:477) ~[jdk.scripting.nashorn:?]
        at jdk.nashorn.api.scripting.NashornScriptEngine.evalImpl(NashornScriptEngine.java:433) ~[jdk.scripting.nashorn:?]
        at jdk.nashorn.api.scripting.NashornScriptEngine$3.eval(NashornScriptEngine.java:521) ~[jdk.scripting.nashorn:?]
        at com.x.base.core.project.scripting.JsonScriptingExecutor.eval(JsonScriptingExecutor.java:225) ~[x_base_core_project.jar:?]
        at com.x.query.core.express.plan.Plan.access(Plan.java:304) ~[x_query_core_express.jar:?]
        at com.x.query.assemble.surface.jaxrs.view.BaseAction.dealPlan(BaseAction.java:69) ~[classes/:?]
        at com.x.query.assemble.surface.jaxrs.view.BaseAction.accessPlan(BaseAction.java:58) ~[classes/:?]
        at com.x.query.assemble.surface.jaxrs.view.ActionExecuteWithQuery.execute(ActionExecuteWithQuery.java:70) ~[classes/:?]
        at com.x.query.assemble.surface.jaxrs.view.ViewAction.executeWithQuery(ViewAction.java:139) ~[classes/:?]
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
        at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
        at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
        at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:52) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:124) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:167) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$VoidOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:159) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:79) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:475) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:397) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:81) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:255) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.internal.Errors$1.call(Errors.java:248) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.internal.Errors$1.call(Errors.java:244) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.internal.Errors.process(Errors.java:292) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.internal.Errors.process(Errors.java:274) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.internal.Errors.process(Errors.java:244) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:234) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:684) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:394) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:346) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:366) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:319) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:205) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:763) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1633) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:228) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1609) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at com.x.base.core.project.jaxrs.CipherManagerUserJaxrsFilter.doFilter(CipherManagerUserJaxrsFilter.java:51) ~[x_base_core_project.jar:?]
        at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1609) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:561) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:602) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1612) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1434) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1582) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1349) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:59) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:716) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.Server.handle(Server.java:516) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:383) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:556) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:375) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:273) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:375) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:773) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:905) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at java.lang.Thread.run(Thread.java:834) ~[?:?]
Caused by: jdk.nashorn.internal.runtime.ECMAException: TypeError: Cannot read property "view" from undefined

论坛管理员

您具体一点，哪里使用这个视图？

woaiyingch

论坛管理员 发表于 2023-4-19 09:47
您具体一点，哪里使用这个视图？

在内容管理里面，

论坛管理员

内容管理的嵌套视图吗，管理员这边测试没有问题呢，您是否方便升级一下o2server

woaiyingch

论坛管理员 发表于 2023-4-20 10:12
内容管理的嵌套视图吗，管理员这边测试没有问题呢，您是否方便升级一下o2server

...

我升级过了，速度还是一样的慢，所以不知道什么原因

论坛管理员

您用的什么数据库？数据库优化一下

woaiyingch

论坛管理员 发表于 2023-4-20 17:00
您用的什么数据库？数据库优化一下

自带的 H2