Обсуждение: M$ Access as fronted for pg with pgsqlodbc

Hi,

We are developing an application on ms access that will become the frontend for psotgresql, the application will be used by more than 40 workstations, the apps is for registration of students.

We are very much concerned about the speed, any tips to avoid while developing application in M$ Access as front end?

This is our first time to use posgresql and be implemented as school wide database backend.

thank you very much!
oca

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

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 -----