Re: interface for "non-SQL people"

On Fri, Oct 9, 2009 at 12:18 PM, Joshua D. Drake <jd(at)commandprompt(dot)com> 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
>
>