Who's On?

	Membership:
	Latest: Hitman
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5208

	People Online:
	Visitors: 386
	Members: 0
	Total: 386

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

Array size limit

5 Replies

1 Subscribed to this topic

52 Subscribed to this forum

Sort:

Author

Messages

Ragu Raghavan

Veteran Member

Posts: 476

11/26/2019 6:55 PM

In my flow, I need to lookup a custom table outside the Lawson schema for each transaction. The SqlQry takes a long time. I wonder, if I can do a single qry at the beginning and load the results of the Sqlqry into an Array, avoiding the multiple lookups. Catch is that there are likely to be 50,000 records in the custom table. Will that cause the LM server to crash? Are there any limits to how big the array can be? Thanks.

David Williams

Veteran Member

Posts: 1127

11/26/2019 7:11 PM

I think that's an excellent solution and the system should have no problem with the size of your array.
http://consultdavidw.blog...eference-lookup.html

Ragu Raghavan

Veteran Member

Posts: 476

11/26/2019 7:25 PM

Thanks David

John Henley

Posts: 3353

11/26/2019 7:27 PM

I use similar approaches with multidimensional arrays to store key/value lookups and can offer this advice. 1) be careful how much you store per row. Don’t try to store a whole bunch of columns just what you need. 2) multidimensional arrays are not very easy to maintain within a flow. The person who comes along after you may not be as smart

3) don’t expect a silver bullet. Execution time may not substantially improve since another factor may be limiting.

Ragu Raghavan

Veteran Member

Posts: 476

11/26/2019 7:37 PM

Thanks for the warning, John.

Ragu Raghavan

Veteran Member

Posts: 476

11/29/2019 9:30 PM

That seems to have worked out well. 17K look ups replaced by 1 lookup and populate array: reduced elapsed time from 1hr+ to about 11 minutes