The library task list is slow.

[trump]

Version: Windchill Below 11.0

Use Case: I've added a filter condition for creation time (time range), and the library task list has become very slow. windchill version windchill10 M030

Description:

I've added a filter condition for creation time (time range), and the library task list has become very slow.

windchill version windchill10 M030

[Fadel]

Can you add the screenshot's in English 

[trump]

Querying all data is faster than adding a creation time range query. The creation time filter logic is not pushed down to the database; instead, filtering is performed via memory and CPU, and there is no full table scan in this case.

Additionally, my computer resources are very sufficient.

I suggest you decompile the following code to check the logic: the creation time isn't pushed down to the database, and the filtering is done in memory. Please help with in-depth research.

[joe_morton]

If it fits your use case, add more filtering criteria. I see in the screenshot that over 2000 items was returned. If you can filter to return less data, the performance will be better.

Alternatively, try removing some columns if there are columns you don't need in the view. This will also improve performance.

Lastly, consider if your Windchill server has enough resources. 

[avillanueva]

I would also suggestion watching the database transactions when the page is selected, on a quiet time. Look for long running queries. You might be able to identify the query or it doing a full table scan. An index can be created to speed things up or perhaps looking at existing indexes, reformulate the filter to achieve similar results to take advantage of existing queries. Also consider upgrading to supported version.

[trump]

Querying all data is faster than adding a creation time range query. The creation time filter logic is not pushed down to the database; instead, filtering is performed via memory and CPU, and there is no full table scan in this case.

Additionally, my computer resources are very sufficient.

[trump]

I followed your instructions, but it didn't work. I suggest you decompile the following code to check the logic: the creation time isn't pushed down to the database, and the filtering is done in memory.Additionally, my computer resources are very sufficient.

[trump]

Please help with in-depth research.