Re: 500 times slower - Mailing list pgsql-odbc

From Dave Page
Subject Re: 500 times slower
Date
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E4528A0B@ratbert.vale-housing.co.uk
Whole thread Raw
In response to 500 times slower  (Karol Szkudlarek <karol@mikronika.com.pl>)
List pgsql-odbc

> -----Original Message-----
> From: Karol Szkudlarek [mailto:karol@mikronika.com.pl]
> Sent: 09 February 2005 14:06
> To: Dave Page
> Cc: pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] 500 times slower
>
> Hi Dave!
>
> In my test case I read LOB of 10 megabytes size.
> So then in the function (with 4kB SOCK_BUFFER_SIZE):
>     SOCK_get_next_byte(SocketClass *self)
> below line (socket.c):
>
> self->buffer_filled_in = recv(self->socket, (char *) self->buffer_in,
> self->buffer_size, 0);
>
> runs in the following schema: 0msec, 200msec, 0msec, 200msec... etc.
> So above times suggest delayed ACK timer (200msec).

OK, that figures. I (and others I've asked) cannot see a reason not to
increase the buffers size other than the extra memory that'll be used
(which is trivial). Anyone disagree before I do so?

Regards, Dave.

pgsql-odbc by date:

Previous
From: Karol Szkudlarek
Date:
Subject: Re: 500 times slower
Next
From: Jeff Eckermann
Date:
Subject: Re: Access/Postgresql problem with text fields recognized as memo