Posted by Sandman on 11/19/72 11:46

In article <aJ95g.39$A54.25@newsfe2-gui.ntli.net>,
Colin McKinnon
<colin.thisisnotmysurname@ntlworld.deletemeunlessURaBot.com> wrote:

> Sandman wrote:
>
> > In article <e2vf80$cn7$1@news.tiscali.fr>, "AlGorr" <a@a.com> wrote:
> >
> >> Sandman thanks a lot !!!!!!!!!!!!!!!!!!!
> >> That's much better! I will use your exemple.
> >>
> >> Only look:
> >> we have to ask 4 times the server for these 4 queries. It's a SQL
> >> question. Is it possible to put for ex. 2 queries in one big and make
> >> work the server more faster?
> >
> > Nah, not more efficient. It's still four queries with four different
> > rules. They all need to be executed separately.
> >
>
> Actually you could do strange things with cartesian products but it may be
> messy depending on how the database is set up. Presumably if AlGorr needs
> to look at it it's because there is a performance issue. First place to
> start with performance issues in database queries is.....the database. Not
> the application language.

Indeed - I didn't interprete "shorter and better" as being that,
though. BUt now that you say it...

Indexes is a good place to start for single-value lookups

--
Sandman[.net]

[Back to original message]