Resource Query Taking a long time to run

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

Steve Martin

Basic Member

Posts: 6

1/12/2011 9:30 PM

I have created a new PF that is doing a resource query that is running for 'People' so that I can pull data for all users.
The resource query is taking over 6 hours to run. I don't have any filtering criteria defined since I want data for all users, I also do not have any sort defined.
There are only around 7300 records that are being returned in the query.
Any ideas on how I can speed this turtle up??
Any help will be very much appreciated!!

We are running PFI 9.0.1.6.

Thanks!

David Williams

Veteran Member

Posts: 1127

New Poster

1/12/2011 9:53 PM

This must be a new bug in Lawson. I have a flow with a ResourceQuery as well and mine does have select criteria. Sometimes when it runs it takes a few seconds and at other times it takes quite a while. I've been canceling my WorkUnit when it happens and then restarting it and the 2nd time it works correctly.

Shane Jones

Veteran Member

Posts: 460

1/14/2011 4:06 AM

I have an audit flow that does a resource query of all users and even verifies all of the bookmark groups ... Runs for about 1300 users in around 10th minutes.

Steve Martin

Basic Member

Posts: 6

1/14/2011 8:56 PM

I finally got this to work much quicker, about 11 mins instead of 6 hours.

I originally was getting all of the RM information out of my 1st resource query and then getting the remaining identity information out of additional resource queries.

I changed it so that the 1st query ONLY gets the ID data.
Then the 2nd query uses that ID to get the other RM data, then continues as it did before using additional queries to get the other identity information.

JudeBac

Veteran Member

Posts: 129

New Poster

1/19/2011 2:36 PM

That is nice. Mine also runs for 10 minutes.