IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / MySQL has lots of ah incompleteness in it's optimizer.
Post #294,820
by static
Picture of static
10/19/07 12:01:14 AM
Reply
New MySQL has lots of ah incompleteness in it's optimizer.
It's mostly recent stuff, so they clearly have more work to do there.

Sub-selects is one area like that. I remember my web developers practically drooling over sub-selects when we finally upgraded the production databases. Turns out they are way too slow for many things. If you can restructure it as an Inner Join (even with a temporary table), it will be a lot faster. Like hundreds of times faster.

Wade.

Is it enough to love
Is it enough to breathe
Somebody rip my heart out
And leave me here to bleed
 
Is it enough to die
Somebody save my life
I'd rather be Anything but Ordinary
Please



-- "Anything but Ordinary" by Avril Lavigne.

· my ·
· [link|http://staticsan.livejournal.com/|blog] ·
· [link|http://yceran.org/|website] ·
Post #294,822
by crazy
10/19/07 12:25:56 AM
Reply
New I have a tough time restructuring
We are creating a generic table driven GUI (Web 2.0 Goodness) front end. The tables can vary tremendously on the backend. So multi stage selects with temp table are right out, since we would have define some type of templating language to drive the query creation, which I want to avoid.
Post #294,844
by static
Picture of static
10/19/07 9:19:44 AM
Reply
New Fair enough.

Is it enough to love
Is it enough to breathe
Somebody rip my heart out
And leave me here to bleed
 
Is it enough to die
Somebody save my life
I'd rather be Anything but Ordinary
Please



-- "Anything but Ordinary" by Avril Lavigne.

· my ·
· [link|http://staticsan.livejournal.com/|blog] ·
· [link|http://yceran.org/|website] ·
     Hey Greg! Database choice time - (crazy) - (40) - Oct. 4, 2007, 06:20:01 PM EDT
         PICK? /me dux -NT - (boxley) - (1) - Oct. 4, 2007, 09:03:58 PM EDT
             You can't duck low enough. </CLUB> -NT - (crazy) - Oct. 4, 2007, 09:47:10 PM EDT
         Firebird? - (CRConrad) - Oct. 5, 2007, 02:22:09 AM EDT
         Well, I've got a new religion lately... - (folkert) - (21) - Oct. 5, 2007, 02:51:03 AM EDT
             Hmm, are they repeating Oracle's error: TOO MUCH "tweakage"? -NT - (CRConrad) - Oct. 5, 2007, 02:56:36 AM EDT
             :-O - (static) - Oct. 5, 2007, 07:02:13 AM EDT
             Oh and here is the MySQL Proxy page - (folkert) - Oct. 6, 2007, 12:01:27 AM EDT
             Ok, playing with 5.0 - (crazy) - (14) - Oct. 8, 2007, 04:40:50 PM EDT
                 Some things are still slow in MySQL. - (static) - (13) - Oct. 8, 2007, 11:09:32 PM EDT
                     Oh yeah - I forgot about that - (crazy) - (12) - Oct. 8, 2007, 11:59:22 PM EDT
                         I saw an Oracle guy do a Bit Of Learning... - (static) - (11) - Oct. 9, 2007, 03:28:52 AM EDT
                             You teased me - (crazy) - Oct. 9, 2007, 09:20:16 AM EDT
                             On the other hand, maybe those MySQL people - (crazy) - (9) - Oct. 9, 2007, 04:58:50 PM EDT
                                 OT have you looked at hadoop? - (boxley) - (5) - Oct. 9, 2007, 09:52:48 PM EDT
                                     Nope - (crazy) - Oct. 9, 2007, 10:35:25 PM EDT
                                     /me rubs eyes - (imqwerky) - (3) - Oct. 10, 2007, 08:37:47 AM EDT
                                         You might have read it, but it's not what it said. -NT - (CRConrad) - (2) - Oct. 10, 2007, 04:48:24 PM EDT
                                             I'm aware of that now - (imqwerky) - (1) - Oct. 10, 2007, 05:15:03 PM EDT
                                                 Ah. Forgot to get your head out, hadya? - (CRConrad) - Oct. 10, 2007, 05:26:34 PM EDT
                                 Interesting. - (static) - (2) - Oct. 9, 2007, 10:21:48 PM EDT
                                     "It's a bit of extra work" - not that much - (crazy) - (1) - Oct. 9, 2007, 10:38:18 PM EDT
                                         Ah. I see. Wouldn't suit my use. :-) -NT - (static) - Oct. 10, 2007, 07:22:01 AM EDT
             You play with partitioning yet? - (crazy) - (2) - Oct. 10, 2007, 12:56:07 PM EDT
                 Nevermind - needed key() -NT - (crazy) - (1) - Oct. 10, 2007, 01:14:55 PM EDT
                     Unusable - (crazy) - Oct. 10, 2007, 01:37:10 PM EDT
         Rare updates, mostly reads? - (admin) - (4) - Oct. 5, 2007, 09:51:00 AM EDT
             Still need SQL access - (crazy) - (3) - Oct. 5, 2007, 08:28:30 PM EDT
                 there is a sql like addon for berkley I dont care for it tho -NT - (boxley) - Oct. 6, 2007, 11:35:12 AM EDT
                 "Guide to Oracle Berkeley DB for SQL Developers": - (CRConrad) - (1) - Oct. 6, 2007, 01:46:11 PM EDT
                     I'm sorry, you must have thought I wote (new thread) - (crazy) - Oct. 6, 2007, 03:18:43 PM EDT
         Here we go again - (crazy) - (9) - Oct. 18, 2007, 10:01:39 PM EDT
             Did you use what version of MySQL. - (folkert) - (2) - Oct. 18, 2007, 10:49:57 PM EDT
                 No you didn't - (crazy) - (1) - Oct. 18, 2007, 11:29:40 PM EDT
                     This is the 5.1 list of enchancements - (crazy) - Oct. 18, 2007, 11:35:25 PM EDT
             MySQL has lots of ah incompleteness in it's optimizer. - (static) - (2) - Oct. 19, 2007, 12:01:14 AM EDT
                 I have a tough time restructuring - (crazy) - (1) - Oct. 19, 2007, 12:25:56 AM EDT
                     Fair enough. -NT - (static) - Oct. 19, 2007, 09:19:44 AM EDT
             Sigh... Didn't look too deeply into Firebird, didja? - (CRConrad) - (2) - Oct. 19, 2007, 06:36:52 AM EDT
                 Sigh - This time it's an option - (crazy) - Oct. 19, 2007, 07:50:50 AM EDT
                 Ehh, you never CARED! - (crazy) - Oct. 19, 2007, 06:05:16 PM EDT

Any more than we can resent a dog licking its own testicles.
74 ms