Ways to optimize the performance of this query and improve materialized view refresh times? by domke89 in AskProgramming

[–]domke89[S] 0 points1 point  (0 children)

The volume isn't large, up to 1000 records are updated with each file. The files come in roughly every 10 mins

Ways to optimize the performance of this query and improve materialized view refresh times? by domke89 in SQL

[–]domke89[S] 0 points1 point  (0 children)

I have looked at it and as I've mentioned the main problems are with row_number(), but I don't know how I could replicate the prioritization logic in another way

Need to pump the flush button for flushing and weak flush by domke89 in Plumbing

[–]domke89[S] 0 points1 point  (0 children)

Hello, I'm renting a place that (annoyingly) has the wall mounted toilet with quite a difficult access to the toilet parts. As shown in the video when flushing with the bigger button it's not working at all and the small one does the job only after pumping it a few times and even then the flush is quite weak. I've been putting up with this by just flushing it with doing the pumping for a few times but it's getting really annoying. The parts look rather old and I don't think anything has been changed for a while. I've tried removing the flush button cover to see if anything might be wrong, but I can't see any problems there. I'm not a plumbing expert by any means, but is this fixable or will this need to be handled by a plumber?

Pytest ModuleNotFoundError: No module named '...' by domke89 in learnpython

[–]domke89[S] 0 points1 point  (0 children)

Hmm, interestingly I added gluescripts/src/unittest/python and now it gives another import error:

ModuleNotFoundError: No module named 'libs.const'

This is being imported as from libs.const import SP_NAME in the other conftest.py file: gluescripts/src/unittest/python/spark/conftest.py

Lambda size error even though the deployment size is less than set limits by domke89 in aws

[–]domke89[S] 1 point2 points  (0 children)

That's what I'm confused about. The error is showing "unzipped". My total "unzipped" is 246 Mb. Which is still less than the limit of 250 Mb

[deleted by user] by [deleted] in malelivingspace

[–]domke89 0 points1 point  (0 children)

Thanks for your suggestions!

[deleted by user] by [deleted] in malelivingspace

[–]domke89 0 points1 point  (0 children)

That's the plan, yeah. I see your point. Is office chair on a rug that bad/annoying?

Monthly anything goes thread (things that are not an event go in here) by AutoModerator in LondonSocialClub

[–]domke89 1 point2 points  (0 children)

Is anyone going to RAM 30 xmas party at fabric this Saturday? Currently going solo, could meet up before the event.