G'day
@DW,
@Licere,
@Al,
@Paul and all the other members,
Hope you are having a great Christmas

Here in Oz we had ours yesterday.
Sorry I haven't responded sooner to DW's tagging. Life's been very full on.
I sew uppers at 14 to 24spi, depending on circumstances/requirements, and I am certainly wanting to lean towards finer as time goes on. The current order's tongues ended up at 24spi; I was aiming for 20 so was pleasantly surprised at the, consistent, higher count. What had happened was that the slight bulge made in the leather by the thread being pulled through was catching the light from my window and I was unconsciously putting my awl in at the edge of that shine. Then I realised I had to repeat that for the other tongue
Interestingly, later, when doing the much longer seam of galosh to vamp, on this order, I found it hard to keep a lower spi (was aiming for 14 - 18spi) after the much finer count for the tongues.
Licere, I haven't found it a problem, strength wise, going for finer stitch counts in uppers (the veg. kangaroo is superb leather), as when you hand sew with hand rolled threads the holes you make are smaller than the threads you're pulling through them on account of the long fine tapers you create on the ends, and the fine pig's bristles you braid on as your needles. I use all manner of bristle size from 8" ones for inseaming, all the way down to 2" ones for fine upper sewing.
As an example of the strength of hand sewing, during the 'discussion' DW alluded to from some years ago about the 'impossibility' of 64spi, and high stitch counts causing the leather to be rendered useless, I split down some 'roo to 1/4mm thick (didn't think I'd be able to put parallel holes through a total of 2mm of 'roo) , placed two pieces together and stitched them at 48spi for the distance of a single inch. I had pre-holed 64spi, but when it came to sewing I only managed to find 48 of them

This took 3/4hr to sew. I later found that it was quicker, and was able to get a slightly higher stitch count (up to 52spi so far), by not pre-holing. The holes from the awl, which had a 0.5mm cutting edge, were put through like this: IIIIIIIII The distance between the holes was less than the height of the holes.
@das points out that for very fine work the awls tended to be just a fine point.
Anyway, back to the 48 test. After the sewing was complete I attached a small vice under a bench and put one half of the test in it, and put the other half in a hand vice and hung a board off it. I then started adding weights to see what it could hold. Here's a close up. I apologise for the quality of the photos as it's back in 2010 and we only had a web cam at that time.
the setup close.jpg
This photo shows 12kg/26.46lb on the board; which you can see is bending a bit.
12kg.jpg
I then added 2 more kg, 4.4lb, and the hand vice lost it's grip on the lower piece and twisted off pulling from one end momentarily, tearing about 1/3 of the stitches through the leather before the vice completely came off the 'roo. The thread I used was a single ply of 40yr old Australian spun linen thread with about a 1.36kg/3lb breaking strain. The stitches that were pulled through the leather were still intact. In hind sight I should have got some sandpaper and lined the jaws with it, reset it up and continued to total destruction, but as it was such a lot of work doing the sewing (and like nothing I'd ever tried before) I didn't want to
Here's a pic of the damaged piece, and one (using a proper Nikon some years later) of another inch I sewed at 50ish spi. The ruler underneath is showing 64th".
damage closeup.jpg
50-something-a.jpg
I'm putting these up, not to big note myself but, to show that, with decent leather (this was only a 1/4 of it's original thickness), high hand stitch counts don't kill the leather's strength (I am quite sure a 'roo shoe sewn like this could be lasted fine), and that it is possible, and I encourage any who are interested in hand sewing to reach for the stars.
Cheers
Duncan
You do not have the required permissions to view the files attached to this post.