First time here? Check out the FAQ!
0

severe performance issues for Laredo queries

  • retag add tags

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

http://lbr-rets.paragonrels.com/rets/...

jflaig's avatar
jflaig
asked 2022-08-11 07:40:23 -0500
edit flag offensive 0 remove flag close merge delete

Comments

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

bwolven's avatar bwolven (2022-08-11 15:44:07 -0500) 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's avatar jflaig (2022-08-11 15:45:12 -0500) edit

problem seems to have cleared up overnight whatever it was

jflaig's avatar jflaig (2022-08-12 08:55:02 -0500) edit

Are you still getting listing data returned?

bwolven's avatar bwolven (2022-08-12 09:23:49 -0500) edit

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

jflaig's avatar jflaig (2022-08-12 09:45:10 -0500) edit

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

http://lbr-rets.paragonrels.com/rets/...

jflaig's avatar jflaig (2022-08-12 09:45:57 -0500) 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's avatar bwolven (2022-08-12 10:22:08 -0500) edit

Was the MLS able to fix this for you?

bwolven's avatar bwolven (2022-08-15 08:45:36 -0500) edit
add a comment see more comments

1 Answer

0

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

http://lbr-rets.paragonrels.com/rets/...

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

jflaig's avatar
jflaig
answered 2022-08-15 08:48:20 -0500
edit flag offensive 0 remove flag delete link

Comments

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

bwolven's avatar bwolven (2022-08-15 08:56:02 -0500) edit
add a comment see more comments

Your Answer

Login/Signup to Answer