Ask Your Question

severe performance issues for Laredo queries

asked 2022-08-11 07:40:23 -0600

This query is consistently taking 2-4 minutes to run for a couple of days now. I'm not sure I've ever seen such poor performance for what should be a light query that only returns 233 results. Any ideas? It seems like the performance issues are recent.

LOGIN: Constellationwebsolu

edit retag flag offensive close merge delete


I am able to duplicate the issue with your account.
Will have to do more analysis to determine the cause.

bwolven gravatar imagebwolven ( 2022-08-11 15:44:07 -0600 )edit

I'm also wondering if there are some query concurrency limits in place -- something we don't normally every really experience as a problem.

jflaig gravatar imagejflaig ( 2022-08-11 15:45:12 -0600 )edit

problem seems to have cleared up overnight whatever it was

jflaig gravatar imagejflaig ( 2022-08-12 08:55:02 -0600 )edit

Are you still getting listing data returned?

bwolven gravatar imagebwolven ( 2022-08-12 09:23:49 -0600 )edit

oh, I see. No. That query now returns no data. that does not seem right.

jflaig gravatar imagejflaig ( 2022-08-12 09:45:10 -0600 )edit

this returns no data either, which can't be right:

jflaig gravatar imagejflaig ( 2022-08-12 09:45:57 -0600 )edit

What I see today is that a different profile was assigned to your account.
That profile only allows listings from the REDFIN office which I assume is incorrect.
It was changed yesterday by one of the MLS staff.
You will need to contact the MLS directly to request it be fixed.

bwolven gravatar imagebwolven ( 2022-08-12 10:22:08 -0600 )edit

Was the MLS able to fix this for you?

bwolven gravatar imagebwolven ( 2022-08-15 08:45:36 -0600 )edit

1 Answer

Sort by ยป oldest newest most voted

answered 2022-08-15 08:48:20 -0600

yes, but before we had access to the U_UpdateDate field in the Office class and now we do not. In the Agent class we do have access to the U_UpdateDate field. Not sure how this happened. Can it be fixed ASAP, otherwise we cannot download Office data incrementally.

Login: Constellationwebsolu

RETS Reply Code: '20200'; RETS Reply Text: 'Unknown Query Field [O_UpdateDate].'

edit flag offensive delete link more


Great. I fixed the O_UpdateDate field and updated your other question.

bwolven gravatar imagebwolven ( 2022-08-15 08:56:02 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2022-08-11 07:40:23 -0600

Seen: 62 times

Last updated: Aug 11 '22