Re: Targeting two fields with the same query or one field gathering contents from both ?

2010-05-17 Thread Xavier Schepler

Le 17/05/2010 17:49, Marco Martinez a écrit :

No, the equivalent for this will be:

- A: (the lazy fox) *OR* B: (the lazy fox)
- C: (the lazy fox)


Imagine the situation that you dont have in B 'the lazy fox', with the AND
you get 0 results although you have 'the lazy fox' in A and C

Marco Martínez Bautista
http://www.paradigmatecnologico.com
Avenida de Europa, 26. Ática 5. 3ª Planta
28224 Pozuelo de Alarcón
Tel.: 91 352 59 42


2010/5/17 Xavier Schepler

   

Hey,

let's say  I have :

- a field named A with specific contents

- a field named B with specific contents

- a field named C witch contents only from A and B added with copyField.

Are those queries equivalents in terms of performance :

- A: (the lazy fox) AND B: (the lazy fox)
- C: (the lazy fox)

??

Thanks,

Xavier




 
   

yes you're right I figured it after posting.



Re: Targeting two fields with the same query or one field gathering contents from both ?

2010-05-17 Thread Marco Martinez
No, the equivalent for this will be:

- A: (the lazy fox) *OR* B: (the lazy fox)
- C: (the lazy fox)


Imagine the situation that you dont have in B 'the lazy fox', with the AND
you get 0 results although you have 'the lazy fox' in A and C

Marco Martínez Bautista
http://www.paradigmatecnologico.com
Avenida de Europa, 26. Ática 5. 3ª Planta
28224 Pozuelo de Alarcón
Tel.: 91 352 59 42


2010/5/17 Xavier Schepler 

> Hey,
>
> let's say  I have :
>
> - a field named A with specific contents
>
> - a field named B with specific contents
>
> - a field named C witch contents only from A and B added with copyField.
>
> Are those queries equivalents in terms of performance :
>
> - A: (the lazy fox) AND B: (the lazy fox)
> - C: (the lazy fox)
>
> ??
>
> Thanks,
>
> Xavier
>
>
>
>


Re: Targeting two fields with the same query or one field gathering contents from both ?

2010-05-17 Thread Xavier Schepler

Le 17/05/2010 16:57, Xavier Schepler a écrit :

Hey,

let's say  I have :

- a field named A with specific contents

- a field named B with specific contents

- a field named C witch contents only from A and B added with copyField.

Are those queries equivalents in terms of performance :

- A: (the lazy fox) AND B: (the lazy fox)
- C: (the lazy fox)

??

Thanks,

Xavier



I made some tests and it appears than the second query is much faster 
than the first ...