From: | "Pliszka, Jacek" <jacek(dot)pliszka(at)hp(dot)com> |
---|---|
To: | Mike Landl <mlandl(at)4glsol(dot)com> |
Cc: | "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: Adding memory query cache to ODBC driver |
Date: | 2013-12-09 17:42:11 |
Message-ID: | 4B9996AA8F503F4B8333DBC7802D6B9409C9A494@G5W2715.americas.hpqcorp.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Landl | 2013-12-09 18:14:26 | Re: Adding memory query cache to ODBC driver |
Previous Message | Pavel Raiskup | 2013-12-09 17:31:59 | Re: Problems with linking against PostgreSQL 8.4 |