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 / No you didn't
Post #294,817
by crazy
10/18/07 11:24:35 PM
10/18/07 11:29:40 PM
Reply
New No you didn't
You said:

Try the pre v6 stuff first, its pure gold.

and

use MySQL v.latest.(stable or devel) or use pre v6 stuff

I did V5.0 1st.
When I tried 5.1, I got into some lib dependancy issues. It's certainly not in stable, which is a bit scary.

If you are telling me there is significant speeds on query, then I'll try again. But if you are referring to all the new whizbang features (and yes, there are LOTS) that I don't care about, then I'll pass.
Expand Edited by crazy Oct. 18, 2007, 11:29:40 PM EDT
Expand All History
Post #294,818
by crazy
10/18/07 11:35:25 PM
Reply
New This is the 5.1 list of enchancements
[link|http://dev.mysql.com/doc/refman/5.1/en/mysql-nutshell.html|http://dev.mysql.com...sql-nutshell.html]

The only thing referenced is the partitioning and that doesn't help the initial poor SQL optimization for the straight selects of smallish tables.

I think I'm expecting too much since I have my Oracle experience.
     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

And, of course, steaming poo...
64 ms