Re: [GENERAL] slow queries

On Fri, 18 Sep 1998, Thomas Good wrote:

> On Fri, 18 Sep 1998, David Hartwig wrote:
>
> > I would like to see it!   I was not aware that table aliasing could
> > have any impact on performance.
>
> [SNIP]
> I was a bit amazed myself.  Federico Passaro, on the SQL list,
> helped me out some time ago when a query was failing.
> His code worked so well that I filed it away for a rainy day...
> this week I decided to try it and see if it helped hasten my
> slooooowest query.  It did.
> [SNIP]

seems that by creating a view ( with the query i mentioned before ), my
queries were sped up by roughly 10 seconds... odd odd odd.

---
Howie <caffeine@toodarkpark.org>   URL: http://www.toodarkpark.org
[[NSNotificationCenter defaultCenter] addObserver:systemAdministrator
  selector:@selector(disableUserAccount:) name:@"UserIsWhining" object:aLuser];