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 ...




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

2010-05-17 Thread 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