Thank you! ----- Message from richard.broersma@gmail.com ---------
Date: Mon, 1 Sep 2008 21:06:59 -0700
From: Richard Broersma <richard.broersma@gmail.com>
Reply-To: Richard Broersma <richard.broersma@gmail.com>
Subject: Re: [ODBC] M$ Access as fronted for pg with pgsqlodbc
To: oca@mvc.edu.ph
Cc: pgsql-odbc <pgsql-odbc@postgresql.org>
> On Mon, Sep 1, 2008 at 6:59 PM, <oca@mvc.edu.ph> wrote:
>
>
>> We are very much concerned about the speed, any tips to avoid while
>> developing application in M$ Access as front end?
>
> 1) do not use nullable booleans on the pg tables. the MS Jet engine
> sees null booleans as false. This makes rows with null booleans not
> update-able.
> 2) When ever possible, perform all large joins on the server not in
> the MS-Query editor.
> 3) SELELT * FROM LargeTable; can be slow, so try to include Where
> Clauses when ever possible to limit result set;
>
> --
> Regards,
> Richard Broersma Jr.
>
> Visit the Los Angeles PostgreSQL Users Group (LAPUG)
> http://pugs.postgresql.org/lapug
>
> --
> Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-odbc
>
----- End message from richard.broersma@gmail.com -----