Posted by Colin McKinnon on 10/12/30 11:46

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.

• Next in forum: Re: Problem to launch a program with system()
• Prev in forum: Re: I am looking fo ropen source package for "appointment package" for Doctors
• Thread view: Re: How to make it shorter and better?

[Reply to this message]