Re: Odbc through vpn

On Fri, 20 Mar 2015 07:57:19 -0700
Adrian Klaver <adrian.klaver@aklaver.com> wrote:

>
> So what happens if you use the previous version of ODBC?

I've tried with the 8.01 version that works fine with postgresql 8.1 but with postgresql 9.4.1
I had the same result.
>

> > For example:
> > I have a table with 5000 records,
> >
> > if i I write select * from table limit 100, the response time is ok
> > about 1 sec,
> > If I write select * from table limit 500 the response time grows to 6-7
> > minutes
>
> Is the above run through ODBC or through another client, say psql?
>
> What application are you using with ODBC to submit queries and get the
> results back?

It's an application written on VB, it's not mine.

regards,
Enrico

--
That's one small step for man; one giant leap for mankind

Enrico Pirozzi
Tel.  +39 0861 1855771 - Mob.+39 328 4164437 - Fax  +39 0861 1850310
http://www.pgtraining.com <http://www.pgtraining.com-> -
info@pgtraining.com
www.enricopirozzi.info - info@enricopirozzi.info
Skype sscotty71 - Gtalk sscotty71@gmail.com