Re: How to make it shorter and better?

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.

C.
Received on Mon May 1 03:08:04 2006