流转流程的时候慢，截取了sql监控 大佬帮忙分析下呗，感谢

zhugx

1.sql 监控

2.http://*********:20020/x_processplatform_assemble_surface/jaxrs/work/v2/2bba303e-e7ed-46c3-9b14-9a9f4c91fe1f/reroute?v=6.1
这个请求 2.45秒



感谢大佬！

zhugx

今天看sql 监控 发现这些慢的，但是 在数据库中直接执行很快，数据库是 sqlserver

启蒙星

你现在使用的o2server是什么版本，单机运行还是集群，另外你与数据库库的连接确认是通过内网的，另外你把红色时间的sql发出来，我看看是否和流程相关的。最后流程流转慢是普通现象吗？简单一个流程单人处理的也慢吗？我看你主贴的地址是执行调度的业务，不是正常流程流转。

zhugx

启蒙星 发表于 2023-11-15 10:27
你现在使用的o2server是什么版本，单机运行还是集群，另外你与数据库库的连接确认是通过内网的，另外你把红 ...

1.版本：V6.2.0.java8
2.单机运行、数据库是内网、服务器内存分了16G，一般占用到  57%，8.9G
3.流转慢是普遍现象。创建、流转、调度很慢，打开、删除都挺快
4.调度那个我是用调度测试了，调度和流转都慢


sql 重新查了一次最慢的

1.SELECT t0.xid, t0.xcreateTime, t0.xsequence, t0.xupdateTime, t0.xdistributeFactor
        , t0.xbooleanValue, t0.xbundle, t0.xdateTimeValue, t0.xdateValue, t0.xitemCategory
        , t0.xitemPrimitiveType, t0.xitemStringValueType, t0.xitemType, t0.xnumberValue, t0.xpath0
        , t0.xpath0Location, t0.xpath1, t0.xpath1Location, t0.xpath2, t0.xpath2Location
        , t0.xpath3, t0.xpath3Location, t0.xpath4, t0.xpath4Location, t0.xpath5
        , t0.xpath5Location, t0.xpath6, t0.xpath6Location, t0.xpath7, t0.xpath7Location
        , t0.xstringLongValue, t0.xstringShortValue, t0.xtimeValue
FROM QRY_ITEM t0
WHERE t0.xitemCategory = ?
        AND t0.xbundle = ?


2.SELECT DISTINCT t0.xprocess
FROM PP_C_TASKCOMPLETED t0
WHERE t0.xapplication = ?


3.SELECT DISTINCT t0.xactivity
FROM PP_C_TASKCOMPLETED t0
WHERE t0.xcompletedTime >= ?
        AND t0.xcompletedTime <= ?
        AND t0.xprocess = ?


4.SELECT COUNT(t0.xid)
FROM PP_C_TASKCOMPLETED t0
WHERE t0.xstartTime > ?
        AND t0.xapplication = ?


5.SELECT t0.xid, t0.xcreateTime, t0.xsequence, t0.xupdateTime, t0.xdistributeFactor
        , t0.xapplication, t0.xbundle, t0.xcount, t0.xentry, t0.xlabel
        , t0.xtag, t0.xtype, t0.xvalue
FROM QRY_SEG_WORD t0
WHERE t0.xentry = ?




6.SELECT DISTINCT t0.xactivity
FROM PP_C_TASKCOMPLETED t0
WHERE t0.xstartTime >= ?
        AND t0.xstartTime <= ?
        AND t0.xprocess = ?


7.DELETE FROM CMS_REVIEW
WHERE xid = ?


8.SELECT DISTINCT t0.xprocess
FROM PP_C_TASKCOMPLETED t0
WHERE t0.xstartTime >= ?
        AND t0.xstartTime <= ?
        AND t0.xapplication = ?


9.SELECT t0.xid
FROM CMS_REVIEW t0
WHERE t0.xdocId = ?
        AND t0.xpermissionObj = ?


10.SELECT t0.xactivityName
FROM PP_C_TASKCOMPLETED t0
WHERE t0.xcompletedTime >= ?
        AND t0.xcompletedTime <= ?
        AND t0.xactivity = ?
ORDER BY 1


11.UPDATE CTE_SCHEDULELOG
SET xupdateTime = ?, xelapsed = ?, xsuccess = ?
WHERE xid = ?

zhugx

启蒙星 发表于 2023-11-15 10:27
你现在使用的o2server是什么版本，单机运行还是集群，另外你与数据库库的连接确认是通过内网的，另外你把红 ...

http://***********:20020/x_processplatform_assemble_surface/jaxrs/work/process/12c6cd06-7a96-457b-8bba-0b97c82afe90?v=6.1
新建流程时 几乎都跑6秒

启蒙星

1.SELECT t0.xid, t0.xcreateTime, t0.xsequence, t0.xupdateTime, t0.xdistributeFactor
        , t0.xbooleanValue, t0.xbundle, t0.xdateTimeValue, t0.xdateValue, t0.xitemCategory
        , t0.xitemPrimitiveType, t0.xitemStringValueType, t0.xitemType, t0.xnumberValue, t0.xpath0
        , t0.xpath0Location, t0.xpath1, t0.xpath1Location, t0.xpath2, t0.xpath2Location
        , t0.xpath3, t0.xpath3Location, t0.xpath4, t0.xpath4Location, t0.xpath5
        , t0.xpath5Location, t0.xpath6, t0.xpath6Location, t0.xpath7, t0.xpath7Location
        , t0.xstringLongValue, t0.xstringShortValue, t0.xtimeValue
FROM QRY_ITEM t0
WHERE t0.xitemCategory = ?
        AND t0.xbundle = ?
这一句慢很有问题，你到数据库执行下这句sql看用时多少，这个表现在有多少数据，xbundle应该有关联的联合索引的，你可以看下执行过程为什么这么慢

启蒙星

另外我看你的版本是6.2，建议你使用全新的8.1到一个新的库（同个数据库不同的db）试试，看看速度怎么样