Re: [PHP-DB] OR on multiple columns

On Friday 10 January 2003 06:41, David Chamberlin wrote: > > That may depend upon your particular circumstances, and hence running > > your own tests on both methods would give you the best answer. > > OK, so what's the best way to go about profiling this? Short answer: microtime() Long answer: c

Re: [PHP-DB] OR on multiple columns

Jason Wong wrote: On Thursday 09 January 2003 08:36, David Chamberlin wrote: I was reading the mysql docs and noticed a section on searching on multiple keys (stupid question - keys=columns?). It says doing an OR on multiple keys is inefficient, and you should use a temp table. Here's their

Re: [PHP-DB] OR on multiple columns

On Thursday 09 January 2003 08:36, David Chamberlin wrote: > I was reading the mysql docs and noticed a section on searching on > multiple keys (stupid question - keys=columns?). It says doing an OR on > multiple keys is inefficient, and you should use a temp table. Here's > their example: > > CR

[PHP-DB] OR on multiple columns

I was reading the mysql docs and noticed a section on searching on multiple keys (stupid question - keys=columns?). It says doing an OR on multiple keys is inefficient, and you should use a temp table. Here's their example: CREATE TEMPORARY TABLE tmp SELECT field1_index, field2_index FROM tes