On Fri, Oct 9, 2009 at 12:18 PM, Joshua D. Drake <jd@xxxxxxxxxxxxxxxxx> wrote: > On Fri, 2009-10-09 at 09:52 -0700, Tim Bruce - Postgres wrote: > >> >> I would also add that there are a LOT of performance issues with MS >> Access. For one, in some cases filtering out records with a where clause >> can be performed on the client side - meaning it grabs all records and >> pulls them across the network and then filters out the results only >> displyaing the results you want to see. I've seen this happen a lot at my >> company, but it may be related to the type of queries being run, so you >> may experience different results. >> > > You solve that with pass through queries. For the benefit of the original poster: Pass through queries in MS Access will require typing SQL code by hand. > > Joshua D. Drake > > >> Tim >> -- >> Timothy J. Bruce >> >> Registered Linux User #325725 >> >> > -- > PostgreSQL.org Major Contributor > Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 > Consulting, Training, Support, Custom Development, Engineering > If the world pushes look it in the eye and GRR. Then push back harder. - Salamander > > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
