Re: Adding memory query cache to ODBC driver

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(at)postgresql(dot)org [mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Pliszka, Jacek
Sent: Monday, December 09, 2013 12:42 PM
To: Mike Landl
Cc: pgsql-odbc(at)postgresql(dot)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 the db - 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(at)postgresql(dot)org [mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Mike Landl
Sent: 9 grudnia 2013 17:03
To: Pliszka, Jacek
Cc: pgsql-odbc(at)postgresql(dot)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(at)postgresql(dot)org [mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Pliszka, Jacek
Sent: Sunday, December 08, 2013 3:22 PM
To: Heikki Linnakangas
Cc: pgsql-odbc(at)postgresql(dot)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 the cache 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(at)vmware(dot)com]
Sent: 8 grudnia 2013 20:54
To: Pliszka, Jacek
Cc: pgsql-odbc(at)postgresql(dot)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 query cache, which would act as a wrapper around any ODBC connection, would be nice.

- Heikki

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

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

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