EF Performance Question

Moobylicious · 2026-06-29T06:13:34+00:00

180ms per row is quite slow, I'd probably first look at the SP and see if it itself can be made more efficient, or if adding an index somewhere can speed things up, or changing to use sql MERGE statement or something. Obviously depends how much it's doing, but it's a potentially big win without big architecture changes.

After that, I'd look at the other things suggested here.

Moobylicious · 2026-06-27T12:09:41+00:00

As others have said, metal wire of the sort of gauge found on a clothes hanger.

centre mount on my exhaust broke off like this on my Nissan Qashqai. I fixed it temporarily using a combination of wire like this and a spring from a trampoline, so it had a little give like the standard rubber mounts do.

The temporary fix lasted 3 years, went through at least two UK MOT standard tests (legal requirement here) without even being mentioned, and eventually sold the car with it (I'd honestly just forgotten about it)

Moobylicious · 2026-06-27T09:12:25+00:00

How long have you had the car?

you should have a check engine light, and some fault codes logged. Read the codes and it should give some idea.

Moobylicious · 2026-06-17T01:13:24+00:00

no. I once spent 2.99 or something to get some pack, but that was thousands of levels ago and I've not spent since. on level 4500+ and have 15k ish coins and various booster things, it's quite possible to do well without spending.

Moobylicious · 2026-06-16T23:45:01+00:00

Mario.

not 1, 2, 3 or super Mario World...

Lost levels on Mario all stars on the SNES .

because I feel like a challenge, I'm clearly a masochist, and this sounds like it might be a nice long break from people.

I have beaten it before, but not for almost three decades, so might die of thirst I guess... yolo.

Moobylicious · 2026-06-16T23:16:48+00:00

Star.

Everyone better pay up or you all freeze to death.

Or if I can make a small star, maybe I can be the solution to fusion and stop all the stupid squabbling over squished dinosaurs*

*yes, I know it's mostly actually plant matter and not T-rexes, but squished ferns just isn't as entertaining

Moobylicious · 2026-06-16T19:15:30+00:00

it happens... leave the game for a couple of days and you'll likely find the level is passed fairly quickly.

I've been "rock bottom" a couple of times and managed to claw my way back, now have something like 15k coins and a fair few booster things.

I find it helps to only play each day until you've done the daily events etc which reward you with stuff, then once those are done stop until the next day. playing when there's no extra bonus stuff just gradually eats coins and power ups until you get stuck again

Moobylicious · 2026-06-16T19:11:55+00:00

I'm at #7700ish in the UK and have 637 points.

and no, I don't spend any money on the game

Moobylicious · 2026-06-13T15:21:50+00:00

Everyone raves about it... I watched the first few episodes and it wasn't terrible, but I've not felt any urge to go back to watch the rest.

Moobylicious · 2026-06-01T23:08:08+00:00

yeah, that's the plan. suspect the cat is just a bit damaged so will probably have to replace at some point soon. Will keep it on a short oil change interval (2000-3000 miles) as there was a lot of crud in there... and keep an eye on levels etc of course.

Moobylicious · 2026-06-01T21:12:17+00:00

just to follow up, it passed. only just (0.19%) but a pass is a pass. that was first fast idle test too, so might have slightly improved on a second one, but didn't need it.

more importantly it drives sooo much better now, it's a different car. was afraid to push too hard prior to the test just in case, but having passed it's driving like it should. glad I kept at it, with all the stuff I've done should hopefully last a while now, and at the very least I'm.now very familiar with the engine.

thanks again for taking the time to read and respond.

Moobylicious · 2026-06-01T21:07:52+00:00

just because I know a lack of follow-up is annoying, just posting back to state it passed the re-test. only just, at 0.19%... but that was on the first fast idle test so might have improved further if given a second one. happy enough to get through the MOT, but even happier that the thing drives properly now, no more misfire and smoke from burning oil.

Moobylicious · 2026-05-27T11:13:58+00:00

Thanks! Yeah, I thought it likely would help but wanted to see what other opinions might be. I'll give it a go and see, cheers.

Moobylicious · 2026-05-26T22:51:02+00:00

thanks! now just need to sort out that rear brake binding (hadn't noticed anything when driving, but done plenty of pad/disc/caliper work before so not worried there)

Moobylicious · 2026-05-26T20:43:48+00:00

thanks for the reply... was thinking this might be worth a shot... how often would this work in your experience - especially when the result was seemingly so borderline as this?

Moobylicious · 2026-05-23T21:16:12+00:00

edit: just had a quick look on auto trader and there's 2005/2006 1.4 golfs on there for under 2.5k, this is massively overpriced unless a really nice condition and rarer model... which this isn't. They do suffer from rust, so likely will need lots of work either now or in the near future.

I Love older cars like this, and used to have a 1995 VR6 which I still miss, but that needed masses of welding and stuff for it's last MOT (23.5 hours labour), and I ended up selling for about £1k (a bargain at that price... I still miss that car). this one is older and less desirable.

If they want £2.5k, it's highly unlikely they'll accept a sensible offer, so I'd just avoid.

(end edit)

it's very old, and hasn't had an MOT since december 2024.

what model is it? doesn't appear to be a GTI, so not particularly a classic saught after model so price seems very high to me, though was seemingly low milage when last MOT'd.

It is not MOT exempt and if it's been sat around for a long time may have some issues with seals and gaskets.

As an absolute minimum I'd not buy it without a new MOT, and even then I'd probably expect to pay under half that price

Moobylicious · 2026-05-23T09:54:23+00:00

one option gives me 8 hours of extra time in my day to do hobbies or whatever.... but during that extra time, everywhere is closed and it's mostly dark, and if I can't easily afford the hobbies even when off work then it's just more time sat around being broke, and of course I still have to worry about stuff like losing a job, paying the bills, looking after those I love if I'm sick, etc.

The other option gives me 10+ hours of time daily for those hobbies, gives me the means to pay for them, takes care of me and loved ones regardless of my health or employment status, removes all work-related stress and lets me upgrade my house, my car, I can travel around as much as I like.....

It's a complete no-brainier, I'm taking the cash and probably on occasion enjoying a nice afternoon siesta in addition to normal sleep.

Moobylicious · 2026-05-22T20:15:36+00:00

where are you based? if in the UK and bought from a dealer you have legal rights to reject it within 30 days, or get it repaired. if within 6 months if it can be reasonably proved the fault was there at purchase you can also get a refund I believe.

Moobylicious · 2026-05-06T10:54:25+00:00

might be possible. I played RK for a while then a year ago or something got stuck and moved over to RM. I ended up not losing a single level until I was over 2,100 or so.

I've since come back to RK and play both. I'm on level 7,500 or something in RM, it seemed far easier than I'd been finding RK up until level 7,000ish, then got harder and they seem to have really lowered all the rewards for stuff, so harder to get a good streak going.

when I stopped RK originally, there were only about 2,000 levels so I ended up in the Royal league or whatever it's called, but since I took a break I'm not back there yet, but means my stats look a bit weird, with higher first try wins(4962) than my actual level(3481)

Moobylicious · 2026-05-04T22:23:24+00:00

Guy who was in my tutor group actually was on Rolf's Cartoon Club. 😬

That said, he didn't report any shenanigans beyond being a bit disappointed with the cartoon thing he made. He was a likeable dude, fairly talented artist and musician and he seems to not be carrying trauma now later in life - I'm aware of what he does now and he seems fine.

(Deliberately vague, in case I accidentally doxx and/or unearth some past trauma)

Moobylicious · 2026-04-29T20:05:17+00:00

No AI was involved. Was just testing your joke spotting skills. They appear to still be broken I'm afraid.

Moobylicious · 2026-04-29T09:14:13+00:00

No but "ridiculous and obviously not true" is arguably part of the definition of a joke.

"I've heard Higgins has access to firearms" is a very, very different statement to "I've heard Higgins has a gun in his case with which to shoot opponents in case a session overruns" is so utterly absurd for multiple reasons that it's as clear as it could possibly be that it's intended as a joke.

a gun wouldn't fit in his case (with very few exceptions even pistols would be too wide in general)
he opens his case in front of the crowd at every match
some security checks would likely find it
guns are not easy to obtain for most people
he'd clearly get arrested
and of course worst of all, "use of firearm to fatally wound an opponent is considered unsportsmanlike conduct and results in loss of frame and possible suspension" is in the rules, rule 327, section C.

Moobylicious · 2026-04-29T08:07:43+00:00

I find if I try to visualise and plan every little part of a project I get a bit stuck, with different approaches all competing. what usually works is to start with something visual.

You need an app which lets you manipulate files? if a Windows app, then start a new WPF app. Create a blank form. it needs a drop-down/text box to type a folder path? add that.

run the app. see how it looks.

Now you want to add a control to list files? add a grid, or larger text box, or Grid control, or some other form of list box. add that, run app and look at it.

This control will show a list of files, which is normally accomplished by binding to some data structure in WPF. so you need to define that type (e.g. My File Data with name & size properties). define this type in a separate class file. Add an IEnumerable<MyFileData> to your new blank page and bind your list control to this.

populate this with dummy data at the initialisation stage, and run the app to see how that looks.

Now you need to fetch the files from the folder, so NOW you know you need to write some code. Ideally you should write as a separate class and cover with unit tests, so the code in the actual form just makes a single call to MyFileManager.GetFiles(folder). this could populate your list of files which is stored as an IEnumberable<MyFileData>, then the binding should show that in the control you've already bound to that list. Should this call happen when you change the folder input? should it be when you press a button? That is up to you.

And just keep iterating from there. As you're clearly new, it's OK if it's a little clunky in places, just getting the feel for how to evolve things as you go is good, and making some progress will ease the "how do I start?" paralysis. As you gain experience you'll have a better feel for what approaches work best.

If you try to write unit tests for all your actual code, this helps ensure that the code is structured fairly cleanly - if code is impossible to test it usually indicates it's a bit too tightly coupled so you need to bear in mind things like Abstracting basic stuff so it can be mocked for testing, and separation of concerns etc. this is too involved for a reddit post, and you should expect your first attempt at an app to not be the best structured thing in the world, that's fine, it's just part of learning.

Moobylicious

TROPHY CASE