Re: Adding memory query cache to ODBC driver - Mailing list pgsql-odbc

Okay, I see what you mean now.
I wish I could help you out but I fear my limited knowledge won't be of much use here.


-----Original Message-----
From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Pliszka, Jacek
Sent: Monday, December 09, 2013 12:42 PM
To: Mike Landl
Cc: pgsql-odbc@postgresql.org
Subject: Re: [ODBC] Adding memory query cache to ODBC driver

Something like this but not quite:

1. pqc is Linux C - I could use myself but majority of users are Windows ODBC clients.

2. pqc looks like based on  pgpool - I would rather use pgpool - but this on the server and my problem Is not load of
thedb - it is the Very Wide Area Network - for this I need the cache as close to client as possible 
- closest thing is ODBC.

Last but not least... I hacked a small crude SQL cache in Python and :

Oracle   : 90s
PostgreSQL  : 85s
MS SQL: 45s
MySQL: 33s
PostgreSQL with my crude cache: 22s

BR,

Jacek

-----Original Message-----
From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Mike Landl
Sent: 9 grudnia 2013 17:03
To: Pliszka, Jacek
Cc: pgsql-odbc@postgresql.org
Subject: Re: [ODBC] Adding memory query cache to ODBC driver

Is this (https://code.google.com/p/pqc/) what you were looking for?
It looks like the project has become stagnant but maybe somebody can resurrect it.

Mike Landl

-----Original Message-----
From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Pliszka, Jacek
Sent: Sunday, December 08, 2013 3:22 PM
To: Heikki Linnakangas
Cc: pgsql-odbc@postgresql.org
Subject: Re: [ODBC] Adding memory query cache to ODBC driver

OK, but as for the last 21 years I've developed for Linux 99% of the standalone ODBC cache is way beyond me.  :) Doing
thecache on the PostgreSQL protocol level looks easier for me. 

And this was an idea to give an option to make PostgreSQL ODBC driver look better than  MS/My SQL. :)

BR,

Jacek

-----Original Message-----
From: Heikki Linnakangas [mailto:hlinnakangas@vmware.com]
Sent: 8 grudnia 2013 20:54
To: Pliszka, Jacek
Cc: pgsql-odbc@postgresql.org
Subject: Re: [ODBC] Adding memory query cache to ODBC driver

On 12/08/2013 10:51 AM, Pliszka, Jacek wrote:
> Hi!
>
> I wonder if it would be possible to add some kind of caching to  the driver.
>
> Something like memory cache in pgpool:

I'm sure that would be useful for many applications, but I don't think that belongs in the driver. A standalone generic
querycache, which would act as a wrapper around any ODBC connection, would be nice. 

- Heikki

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc



--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc