Thread: what's a good cache size?

what's a good cache size?

From
"Patrick Hatcher"
Date:
What is a good cache size to use on the ODBC driver?  I have users in NY
that use Crystal Reports from their desktops against my dbase here in San
Fran.

Patrick Hatcher



Re: what's a good cache size?

From
"Dave Page"
Date:

> -----Original Message-----
> From: Patrick Hatcher [mailto:PHatcher@macys.com]
> Sent: 25 July 2002 18:46
> To: pgsql-odbc@postgresql.org
> Subject: [ODBC] what's a good cache size?
>
>
> What is a good cache size to use on the ODBC driver?  I have
> users in NY that use Crystal Reports from their desktops
> against my dbase here in San Fran.

It may well be irrelevant 'cos Crystal often pulls the entire recordsets
in order to perform joins locally.

If this is not the case though (because of the design of your reports)
then I would suggest experimentation is the best way to figure it out as
it will be affected by factors such as connection speed, latency and the
size of the individual rows themselves.

Regards, Dave.