Two paradigms are available for working with lists. One paradigm uses a list handle for referring to and making queries on a server-side list and the other simply performs a SQL-like select.
If you need to maintain reference to a static list, use the methods that return list handles. These methods are especially useful when working with very large lists. For example, your application may need to perform operations using the entire table of 10,000 Contacts. Downloading values for all 10,000 at once could result in an unacceptable performance lag (this condition is actually prevented by the system—see Where Clauses). With a list handle, however, you can select a range of rows upon which to query.
The primary drawback to using a list handle is the extra method calls it requires. At least two or three calls are necessary, as indicated by the following:
You need to balance the amount of remote method calls versus the expected amount of data returned.
Note: CA SDM restricts the amount of data that can be returned from any one list. For more information, see Where Clauses.
|
Copyright © 2013 CA.
All rights reserved.
|
|