>>>>> "Trevor" == Trevor Phillips <[EMAIL PROTECTED]> writes:
Trevor> I'm trying to do a select on a large set of data, which has a number of
Trevor> conditions. One set of conditions involves checking an Integer column is
Trevor> between a particular range, while another set of conditions involves checking
Trevor> a few text columns contain a certain value.
Trevor> If I JUST do the range check on the integer field, it is lightning fast.
Trevor> However, when I add the string checks, it slows down considerably. I've tried
Trevor> ordering the conditions differently, but this seems to have no effect.
Trevor> Is there any way I can do a select, and get it to prioritise the range check??
Trevor> Once the dataset is narrowed down to that range, the string check should be a
Trevor> lot quicker...
Hi!
Sorry, but without the explicit select + EXPLAIN statements on the
specific queries it's impossible to help you!
Regards,
Monty
-----------------------------------------------------------
Send a mail to [EMAIL PROTECTED] with
unsubscribe mysql [EMAIL PROTECTED]
in the body of the message to unsubscribe from this list.
