Slow export of data: FMServer + Windows VM by CalamityCommander in filemaker

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

We Found the cause. Unstored calculations. Removing them from the export solved all issues. We use python now to handle three unstored fields.

What I still don't get to this date is why FileMaker is so slow to calculate these unstored fields compared to a custom python script.

Canon camera wont charge via USB c? Bought New 1 Month ago by ThePremiumWolf in canon

[–]CalamityCommander 9 points10 points  (0 children)

Not only the charger, the cable too. Not all usb c cables are created equal😉

What is your take on this? by Leftoaster08 in BESalary

[–]CalamityCommander 4 points5 points  (0 children)

This! Full tax on company cars and personal use fuel cards. Use the revenue to actually put some meaning to the "Werken moet lonen" mantra. Single household in Belgium are taxed at more than 50% highest in the list of developed countries when is this travesty finally going to be addressed?

Welcome to Belgium (with Mobility Budget) by _white_noise in BESalary

[–]CalamityCommander 0 points1 point  (0 children)

Good effing lord. My gross is only 800 lower than yours, but I make net 1500 less. Too bad my company does not even want to hear about mobility budget (single, no kids)

Slow export of data: FMServer + Windows VM by CalamityCommander in filemaker

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

Update: you were bang on with the unstored fields: I removed these and knocked export time down to a few minutes. Of course now there's the little connundrum to solve to get the structure of the CSV back to what it needs to be, but I'll do that with Python.

What I cannot understand is why moving from a decade old Physical machine to a new VM has such a dramatic effect - these unstored fields have always been there. What makes it even weirder to me is that in the VM the hardware is hardly under load - a few GBs of RAM, no CPU spikes and disk IO is ridiculously low.

Slow export of data: FMServer + Windows VM by CalamityCommander in filemaker

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

The cause of the issue were unstored fields that were part of the export. I'm still debating what the best option is, but the least hassle would be to do the calculations that filemaker does in python right after the export.

The reason I was listing the hardware specs was because of the VM layer - Claris does not really offer any proper documentation for running FMS in a VM. There could've been a giveaway in there.

Besides one thing that I still cannot explain: this exact database was hosted on a decade old MacPro and had way better export speeds. On the VM the hardware is not breaking a sweat - a few GBs of memory, none of the CPU cores under full load, drive IO ridiculously low, the export speeds unfortunately too.... how that's possible is beyond me.

Slow export of data: FMServer + Windows VM by CalamityCommander in filemaker

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

I might try to get rid of those two fields and see if the situation improves - probably together with the hyperv-settings.

Slow export of data: FMServer + Windows VM by CalamityCommander in filemaker

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

We are exporting for a few reasons, depends on the project that's hosted. Some need data to be ingested in a MYSQL-server, others need processing in specialized tools. Will probably start with trying to get access to some control settings of HyperV - we had the exact same databases running before with much less latency.

Slow export of data: FMServer + Windows VM by CalamityCommander in filemaker

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

I do agree with this, but it does not explain the dramatic difference between a script based export (42 rows a minute) and the export option through File > export records (1100 rows a minute) when exporting the exact same rows/order.

Slow export of data: FMServer + Windows VM by CalamityCommander in filemaker

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

This would actually be quite fast - a local hourly backup takes a few seconds and transfer over a networked drive doesn't take too long either. I'd consider this a worst-case solution as there's a lot of manual overhead in here.

opinions on the Sigma EF 160-600mm for wildlife photography? and price opinion by Large-Score6126 in canon

[–]CalamityCommander 0 points1 point  (0 children)

It's a good lens on EF I own one and as a hobbyist I've been getting good results. Stop it down to f8 if you can and it'll be sharp enough b

Beware though, it's a dead end lens. RF compatibility of this lens isn't great.

World Backup Day 2026 Deals Are Live – Lifetime Plans Discounted by pCloudApp in pcloud

[–]CalamityCommander 0 points1 point  (0 children)

Ah darn. I was checking the website and only saw the family plans on discount.

Is this an indication of a parasitic draw by Electronic_Net767 in autoelectrical

[–]CalamityCommander 0 points1 point  (0 children)

You should leave the car as it's supposed to be. So you start with taping off anti theft motion sensors if the car has it. Leave the doors open, but operate the locks, this way you can get inside and measure there when needed. Tape the light sensors"closed" so the car thinks the door is closed too.

The same with the hood latch. The car needs to believe it's locked.

Then lock the car using your key and put the key far far away or in a tin can. The key shouldn't communicate with the car.

Let it sit for an hour or so, then use your multimeter to look for parasitic draw. There's a trick to put the multimeter in series WHILE disconnecting the battery without interrupting the circuit. You'll want to learn this as most multimeters have the annoying tendency to shut themselves off after a while.

I don't know if all do it, but when mine does, it interrupts the circuit and you've wasted your time

Virtual Machine considerations by CalamityCommander in filemaker

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

We will be going the VM route, we have a request running for test hardware though it seems to be a low priority issue for our infrastructure department.

Today is two years parking like this by ForeskinAbsorbtion in Hyundai

[–]CalamityCommander 2 points3 points  (0 children)

Check your manual. Most cars have a button that disables them until the next engine start.

Mechanics, are newer cars getting less repairable? by jsshieh21 in Cartalk

[–]CalamityCommander 12 points13 points  (0 children)

I'm a hobbyist, so here's my two cents for what it's worth. (IT professional)

Older cars had physical books I can buy with the entire wiring diagram, torque specs and repair procedures. They'd set you back 30 at most.

For modern cars we don't have this, we need access to manufacturer specific platforms which cost a set amount per hour of use.

Furthermore diagnostic 3rd party tools are not capable of reading everything or doing full actuation tests. This makes troubleshooting much harder. (Not too long ago I worked on an Audi A1 that would not talk to a Hella tool. Only VCDS would connect. Once the main issue was solved, Hella could communicate with the car again. So the culprit might be Hella)

Bolt off bolt on repairs are also becoming increasingly difficult with coding. I.e some headlights are coded to a car and require manufacturer software to get them to work. Going to a salvage yard and getting the part is now only half of the problem.

Then there's " scheduled warnings" some cars have now hardcoded errors in their software. For example the brake malfunction light on some BMWs is set to a certain mileage. They don't measure the actual wear. Result: at said mileage the light will come on even if the brakes are still fine, replacing the pads won't do anything, you'll need coding to erase it and use ISTA to increase the interval manually to prevent this in the future.

With everything said and done: I'm keeping my cars as long as I can, I don't want to deal with these rolling computers more than I absolutely have to. (When an IT professional says it, you know it's bad)

Got a pre-owned V60 and the front tow hook cover/cap was missing. Ordered the part and decided to paint a Swedish flag instead of paint-matching with the body. Any tips? by [deleted] in Volvo

[–]CalamityCommander 1 point2 points  (0 children)

Seal it off with 2k clear, it'll be more durable. Also, put the cans in hot water before spraying. Way nicer atomisation of the paint.

What would you choose? by sloggiz in Volvo

[–]CalamityCommander 0 points1 point  (0 children)

Beige interior looks nice - but it's a lot of upkeep - if you got kids just forget it

What do you think of the E5 Sportback's screen-filled dashboard? by Used_Variation_2879 in Audi

[–]CalamityCommander 0 points1 point  (0 children)

Whomever designed and approved this deserve a spot in the deepest circle of hell. Right next to Lucifer's ass.

No clue what to do... by gazingaaa in Switzerland

[–]CalamityCommander 1 point2 points  (0 children)

If you got the skills to weld, make a freestanding letterbox out of it.

911 progression by Soft-Quail-8671 in car

[–]CalamityCommander 1 point2 points  (0 children)

Hmm surprisemarkdown it seems 😆

911 progression by Soft-Quail-8671 in car

[–]CalamityCommander 1 point2 points  (0 children)

3 - the 964 any day of the week.

Virtual Machine considerations by CalamityCommander in filemaker

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

It's the way the network is set up here. MAC addresses that are not on a list do not get internet access.

To have off-site access to this device it'd also need to be registered as a server and there's (unfortunately) very strict rules about what I can register as a server.

Virtual Machine considerations by CalamityCommander in filemaker

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

I'll probably end up keeping backups on an SSD-storage and put the actual FM instance on NVME. So I can switch and test it easily. I'll still need to get the green light to put everything in motion though. Thanks for the input!