Ask Your Question
0

CMSMLS Server Counts Don't Match Actual Records Returned

asked 2021-06-23 11:03:00 -0600

We are seeing that the counts we are getting back are higher than the actual number of records we get back from our queries.

Example: When we send this query with a request for a count only, we are getting back a count of a total of 25338 for all matching listings in the RE_1, LD_2, and MU_3 classes: (L_UpdateDate=2014-01-01+)

But when we send the same query and request the L_ListingID value for all matching records, we are getting only 23462 records back.

We suspect that the difference between what the counts are and what we are actually getting back from our queries is caused by some query quota/limits on the MLS server, such as a restriction on how many IDs we can pull at once and another restriction on how many full records we can pull at one time.

For example, when we attempted to pull all L_ListingID values for all listings in the RE_1 class, we consistently only get exactly 20,000 L_ListingIDs back, but the count indicates that there are actually more than 21,000 records in that class.

Does Central MS MLS have limitations on their system, and if so, what are they? Thanks!

http://cmmls-rets.paragonrels.com/ret...

edit retag flag offensive close merge delete

Comments

Please specify the account name you are using?
There are normally limits set for the number of records per transaction.
These limits can vary by account profile.
When searching and returning the L_ListingIDs are you passing Limit=NONE?

bwolven gravatar imagebwolven ( 2021-06-29 09:13:21 -0600 )edit

Hi! UN is RETS_465

Redfin MLS Team gravatar imageRedfin MLS Team ( 2021-06-29 11:33:14 -0600 )edit

When searching and returning the L_ListingIDs are you passing Limit=NONE?

No, we batch through and pass Limit=2500 for these queries.

Redfin MLS Team gravatar imageRedfin MLS Team ( 2021-06-29 12:43:57 -0600 )edit

If you are batching and updating the 1 based offset correctly it should return all records.

bwolven gravatar imagebwolven ( 2021-06-29 13:31:46 -0600 )edit

Got it thanks! Can you let us know if there are any query limits or quotas that might apply?

Redfin MLS Team gravatar imageRedfin MLS Team ( 2021-06-29 14:13:10 -0600 )edit

1 Answer

Sort by ยป oldest newest most voted
0

answered 2021-07-01 16:34:20 -0600

I checked and it looks like there is a limit of 10,000 per batch.
So if you are using 2500 you should be fine.
When I used your account and compared the count with downloaded ListingIDs I get the same for both. At least with the RE_1 class. I didn't check the rest.
I also did it with Limit=NONE and got the same.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2021-06-23 11:03:00 -0600

Seen: 183 times

Last updated: Jun 23 '21