--
techie
------------------------------------------------------------------------
Posted via http://www.codecomments.com
------------------------------------------------------------------------
e.g.
$searcher.PageSize = 900
gr /\/\o\/\/
In ADO, once you set a Page Size (any value less than 1000), you turn on
paging, which is all you really need. I've never used any value but 100.
I've never seen a discussion of the optimal value, but it would probably
vary depending on the query. A large value might be less efficient.
--
Richard
Microsoft MVP Scripting and ADSI
Hilltop Lab - http://www.rlmueller.net
"/\/\o\/\/ [MVP]" <oM...@discussions.microsoft.com> wrote in message
news:B1E3319F-3A21-466D...@microsoft.com...
Can you elaborate on this? Since I've never had to deal with more than 1000
or so elements in ADSI queries, I generally have set page size to 1000 - but
I thought that was the maximum records you would get. In other words, I had
thought that if I had 1290 computers in ADSI and did a query with page size
set to 1000 explicitly that I would only get the first 1000 back unless I
explicitly did something to advance the page.
If I understand you correctly, you don't have to worry about anything once
you set paging no matter how many results there are?
"Richard Mueller" <rlmuelle...@ameritech.NOSPAM.net> wrote in message
news:uy6l7OFW...@TK2MSFTNGP02.phx.gbl...
the 900 was a "typo" just what I normally do.
only with MemberOf() it's worse you need to use a searcher, to get all
gr /\/\o\/\/
The following link has a discussion on Page Size:
http://www.microsoft.com/technet/community/columns/scripts/sg0405.mspx#E4H
If paging is not turned on, you can only retrieve 1000 records in a
recordset. Once paging is turned on, the recordset returns to the server as
many times as required to retrieve all records matching the query, no matter
how many. Page Size is the number of records returned each time. You can
test by setting Page Size to a small number, like 10.
There is also a limit to how many values of a multi-valued attribute (like
memberOf) can be returned. This limit is also 1000, but can be overcome by
using Range Limits.
--
Richard
Microsoft MVP Scripting and ADSI
Hilltop Lab - http://www.rlmueller.net
"/\/\o\/\/" <n...@spam.mow> wrote in message
news:O$gReOGXG...@TK2MSFTNGP05.phx.gbl...
http://mow001.blogspot.com/2006/04/large-ad-queries-in-monad.html
1) for queries above 1000 objects (simple just set pagesize)
2) for groups with more as 1500 Members (do paging yourself)
gr /\/\o\/\/