Bees are faster than Lightning!

As many of you know I've been running the v4v.app for a good long while now and I've become Hive's leading Lightning Expert (at least according to @blocktrades on a recent Core Dev call).
One of the things I track is how long each transaction takes on my system: Hive to Lightning and Lightning to Hive.
And it's pretty clear which way is quicker and when you find out how Lightning works, you understand what makes Lightning slower than Hive, but unpredictable as well.
Just a reminder: I still need more votes in order to support the @v4vapp service and my work on @podping .


Results

This graph is a histogram of the number of seconds it took to complete a total of 518 transfers from Hive to Lightning and 153 back the other way.
The tall blue tower on the left are the payments of Lightning to Hive, these happen with a mean speed of 3.1s and 90% are complete in under 4s.
The spread out red bars are payments to various Lightning destinations. The mean speed is 215s though 90% of the transactions complete in 30s.

Summary

trx_reason (s)countmeanstdmin25%50%75%90%max
Hive to Lightning518215.333591.35011152030.380205
Lightning to Hive1533.124181.2738322334.011

A few very slow transactions

The Lightning speeds are significantly corrupted by a very few slow transactions:
last_timestamptrx_reasondurationduration_hours
2022-09-22 14:50:48.385000HIVETOLND8020522.2792
2022-11-09 17:58:23.148000HIVETOLND159814.43917
2022-11-08 19:16:12.587000HIVETOLND9160.254444
2022-11-27 15:32:55.040000HIVETOLND9150.254167
2022-12-02 20:10:18.923000HIVETOLND9140.253889
2022-10-21 17:29:12.211000HIVETOLND6120.17
2022-10-14 18:46:49.690000HIVETOLND4100.113889
That's right, the slowest transaction I have (which actually did succeed) took 22 hours, 23 minutes, and 25 seconds. The next slowest was almost 4 1/2 hours. These skew the Lightning results quite a bit.
The slowest payment to Hive was 11s and was actually caused by a networking issue with my equipment rather than anything to do with Hive inherently.

Failures

There were 21 payments to Lightning which were impossible to make and for which all Hive funds were returned. Payment failure son Lightning happen for various reasons but insufficient liquidity at the receiving end is the biggest reason for me. There's nothing much I can do about this. Most of the payments my system makes are to major wallets and these nearly always succeed (though in the case of Muun wallet payments can take a very long time if the user closes their app).
Failures (s)countmeanstdmin25%50%75%90%max
Hive to Lightning21.0024.3370.274.005.006.007.0015.00325.00