Re: Client-server communication for FETCH

2025-12-03 Thread Tim Fors
Thanks for the quick reply Tom. Let me give you a bit of background info: Oracle has a COBOL pre-processor for embedded SQL, and it supports an option named PREFETCH: The precompiler option PREFETCH allows for more efficient queries by > pre-fetching rows. This decreases the number of server rou

Re: Client-server communication for FETCH

2025-12-03 Thread Tom Lane
Tim Fors writes: > I have a simple C program using libpq V18 to FETCH one row at a time (see > below). Does the server send multiple rows to the client where they are > cached for satisfying the FETCH statements, or does it just send one row at > a time since that's all that each FETCH statement i

Client-server communication for FETCH

2025-12-03 Thread Tim Fors
Hello community, I have a simple C program using libpq V18 to FETCH one row at a time (see below). Does the server send multiple rows to the client where they are cached for satisfying the FETCH statements, or does it just send one row at a time since that's all that each FETCH statement is asking