3 ms·
Handling cursors is tough - they are very much session-level objects, so even if we, say, pinned your client while it uses that cursor, which would work, that w
by levkk 4mo ago
Handling cursors is tough - they are very much session-level objects, so even if we, say, pinned your client while it uses that cursor, which would work, that would decrease the performance of connection pooling overall.
So, what's better, breaking your app initially so you know to remove that feature, or letting it work silently while the connection pool isn't 100% in transaction mode? Tough call.
- rst 4mo agoMaybe don't reassign the sesssion to a different client so long as there's a cursor open (the way that most poolers have a mode that won't reassign a session that has a transaction open)?
- mmakeev 4mo ago[dead]
- Maledictus 4mo agoWhich one did you pick?
- levkk 4mo agoPin the client temporarily. I'm assuming that our users know what they are doing. I could be wrong, but so far so good.