Bulk Indexing Performance

[jsirrell]

Version: Windchill 13.0

Use Case: Bulk indexing after Windchill 13.0.2.4 upgrade

Description:

Bulk indexing taking 4 weeks to complete. 

Tested performance against Windchill 12.0.2.10 which is very fast 

Is there a known issue with Windchill 13 

I have gone through all the articles PTC suggested but it makes no difference

[Fadel]

You should raise a performance case, an Perf engineer should review properties file and Queue setting 

[jsirrell]

Thank you for your reply. I have logged a call with PTC and have tried the suggestions. I just need to send them feed back.

[Catalina]

Hi @jsirrell ,

I wanted to see if you got the help you needed.

If so, please mark the appropriate reply as the Accepted Solution or please feel free to detail in a reply what has helped you and mark it as the Accepted Solution. It will help other members who may have the same question.

Of course, if you have more to share on your issue, please pursue the conversation.

Thanks,

[TomU]

If you figure out the issue, please report back to this thread.  I'm curious to know what you find.  Thanks!

[jsirrell · Accepted solution]

Hello Tom,

I had to increase my free disk space to allow for the huge amount of files created. I had 280Gb free but increased it to 780Gb. It needed over 300GB. 

I set the following:-

<Property name="wt.index.maxContentSize" overridable="true" targetFile="codebase/wt.properties" value="1048576"/>

<Property name="wt.index.maxDocumentSize" overridable="true" targetFile="codebase/wt.properties" value="10485760"/>

SOLR_HEAP set to 8192

I processed all objects types individually leaving documents till last (took around 1 day),  I then processed the documents which took a further 4 days

I tested the same bulk index on my Test Windchill 12.0.2.10 and it takes around 1 1/2 days.

Conclusion: The performance of 13.0.2.4 bulk indexing takes 3 times as long as 12.0.2.10. Doing the above helped as It stopped the SOLR service from crashing and was faster than the first rehearsal. It needs fixing by PTC