I think the only clues the optimizer consults with regard to UDFs is the
'characteristic' provided at the time you create the routine.
from http://dev.mysql.com/doc/refman/5.0/en/create-procedure.html
*
*
*characteristic*:
COMMENT '*string*'
| LANGUAGE SQL
| [NOT] DETERMINISTIC
| { CON
Does the optimizer look into function called from query?
In my queries the expression (SELECT hwyl FROM Stock) / (SELECT regularPayment
FROM Stock), where Stock is a one-record table, often is repeated. The
optimizer sees that, and makes the ratio a constant, and I can afford to be
clear. If th
I have a puzzling situation where a query works, but only outside of a
function. If I try to abstract away some of the complexity by placing the
subquery inside a function, the db seems to get stuck in an infinite query
and the entire system becomes unresponsive (from the MySQL console I can
ctrl-c
Donny Simonton wrote:
In our case we were using words, and phrases, so we would have something
like:
IN ('a', 'apple', 'apple car', 'car', 'c') etc...
We found that once it hits about 200 or so entries the query went from 0.00
seconds to about 2-3 seconds. Sometimes much more.
I would guess that
EMAIL PROTECTED]
> Sent: Wednesday, February 16, 2005 9:07 PM
> To: Daevid Vincent
> Cc: mysql@lists.mysql.com
> Subject: RE: What is the max length of IN() function?
>
>
> > -Original Message-
> > From: Daevid Vincent
> > Sent: Wednesday, February
> -Original Message-
> From: Daevid Vincent
> Sent: Wednesday, February 16, 2005 20:59
> To: mysql@lists.mysql.com
> Subject: What is the max length of IN() function?
>
> I tried to find this function on the dev.mysql.com site, but good luck
> finding "in&quo
I tried to find this function on the dev.mysql.com site, but good luck
finding "in"... ;-)
Can someone tell me what the maximum length is for this function?
SELECT * FROM foo WHERE bar IN(1,2,3,4,. N);
How many entries can there be in between 1 and N ? Hundreds? Thousands?
Millions?
--
My
ata\"
-DSHAREDIR=\"/usr/local/mysql-4.1.7/share/mysql\" -DUNDEF_THREADS_HACK
-DDONT_USE_RAID -I. -I. -I.. -I../include -O3 -DDBUG_OFF -MT manager.lo -MD -MP
-MF .deps/manager.Tpo -c manager.c -fPIC -DPIC -o .libs/manager.o
manager.c: In function `mysql_manager_connect':
manager
Yes
--Original Message-
> Hi,
>
> I have written a program that creates statments for me, and sometimes I
> end
> with
> SELECT..WHERE number IN(1)
> instead of
> SELECT... WHERE number IN(1,2,3,4)
> would number IN(1) works,
> for the moment i have no mean to test it, it
Hi,
I have written a program that creates statments for me, and sometimes I end
with
SELECT..WHERE number IN(1)
instead of
SELECT... WHERE number IN(1,2,3,4)
would number IN(1) works,
for the moment i have no mean to test it, it is why i'm asking.
Regards,
Anthony
--
MySQL General Mailing
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:angelos Vasdaris
>Organization:
>MySQL support: [none]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: mysql-3.23.46-max (Source distribution)
[EMAIL PROTECTED] writes:
> >Description:
>
> I am using the recommended ./configure options as specified by:
> http://www.mysql.com/doc/S/o/Solaris.html. I am unsure how to
> specifiy the GNU ld - the output from ./configure shows that I am
> using the Solaris ld. Perha
-DHAVE_CONFIG_H
-I./../include -I./../regex-I. -I../include -I..
-I.-O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti
-fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_CURSES_H
-I/usr/local/src/mysql-3.23.39
sage -
From: "Bobby Chopra" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 26, 2001 2:09 PM
Subject: Using the IN function
> Probably a simple question:
>
> I am returning back to SQL after a break, and I was sure that I could do
the
> follow
EMAIL PROTECTED]
Subject: Using the IN function
Probably a simple question:
I am returning back to SQL after a break, and I was sure that I could do the
following when using the IN function:
SELECT field1 FROM table1 where field1 NOT IN (SELECT DISTINCT field2 FROM
table2);
but clearly not.
Could a
Probably a simple question:
I am returning back to SQL after a break, and I was sure that I could do the
following when using the IN function:
SELECT field1 FROM table1 where field1 NOT IN (SELECT DISTINCT field2 FROM
table2);
but clearly not.
Could anyone suggest what I am doing wrong, or is
16 matches
Mail list logo
