I have a large dataset of lines (ca 400 000). Each line represents a calculated route on the same road network.
My goal is to summarise a total number of calculated trips that pass each part of the road network, ie. a line on line overlay resulting in an overlap count on each segment.
I've tried running it in the line on line overlayer in FME, but I keep running into memory issues. I've also tried intersecting in Spatialite, but have memory issues there as well. I'm stuck on a 32 bit computer at work, so if the answer is "that dataset should be fine on 64 bit with enough RAM" that could be a viable answer. But something also tells me there should be a more elegant way to go about it...
So, in short, what's an efficient way of counting overlaps/intersecting in a large line dataset? I have access to and mainly work with FME, QGIS and R.