tinyows
tinyows copied to clipboard
Retrieve (big) data chunked from database
Right now PostgreSQL is called in GetFeature with a single request, could be interresting to find a way to retrieve datas in several pieces, and so to begin to send them back to client earlier.
At least for quite big dataset.
For big results in general, if you don't do a bunch of FETCH calls you'll end up with the whole result set sent to the client and then iterated on, which could blow out memory if your limits are small enough.
You're right Paul ! Right now network is the first bottleneck, but definitly not a reason to not improve it...