Re: why would LOWER

2001-10-01 Thread Carl Troein
Joe Kaiping writes: Is it expected that using the LOWER function should greatly increase query time? The way you do it, yes. Is that email column a BLOB or a BINARY VARCHAR? If not, why on earth do you do LOWER() on it? And do you have an index on the column? //C -- Carl Troein - Círdan

why would LOWER

2001-09-30 Thread Joe Kaiping
Hi there, Is it expected that using the LOWER function should greatly increase query time? Or is there a MySQL setting that can help speed it up? Below are the results of a query against a table that has an index on cols (email,cust). Using LOWER increases the query time by 10.5 seconds.

RE: why would LOWER

2001-09-30 Thread Will French
To: [EMAIL PROTECTED] Subject: why would LOWER Hi there, Is it expected that using the LOWER function should greatly increase query time? Or is there a MySQL setting that can help speed it up? Below are the results of a query against a table that has an index on cols (email,cust). Using

RE: why would LOWER

2001-09-30 Thread Joe Kaiping
was wondering if something like that may be happening. Thanks for the comments! -Joe -Original Message- From: Will French [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 30, 2001 1:25 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: why would LOWER You didn't mention how large

Re: why would LOWER

2001-09-30 Thread Benjamin Pflugmann
Hi. The problem is that LOWER(email) is an expression and expressions on the left hand side of an comparison cannot use an index with MySQL (see also http://www.mysql.com/doc/M/y/MySQL_indexes.html). If you usually want to compare emails ignoring case, an easier way is to assure that email is

RE: why would LOWER

2001-09-30 Thread Daniel Ouellet
] Subject: RE: why would LOWER You didn't mention how large your table is or if the email and cust fields are part of an index. In many situations, the results you are seeing make perfect sense to me. If email is a part of an index then the LOWER function may need to be performed

RE: why would LOWER

2001-09-30 Thread Joe Kaiping
Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Benjamin Pflugmann Sent: Sunday, September 30, 2001 1:55 PM To: Joe Kaiping Cc: [EMAIL PROTECTED] Subject: Re: why would LOWER Hi. The problem is that LOWER(email) is an expression and expressions on the left hand

RE: why would LOWER

2001-09-30 Thread Haapanen, Tom
MySQL is not Oracle ... and that's a good thing, too! :-) Tom Haapanen [EMAIL PROTECTED] -Original Message- From: Joe Kaiping [mailto:[EMAIL PROTECTED]] Sent: 30 September 2001 19:37 To: [EMAIL PROTECTED] Subject: RE: why would LOWER Thanks to all for your responses. I had missed