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 / Justifiable arrogance in many cases
Post #258,263
by ben_tilly
6/8/06 9:18:47 PM
Reply
New Justifiable arrogance in many cases
Much of what I do with analytic queries you simply Would Not Want to try with MySQL.

Ditto if you are paranoid about your data.

However there is no question that MySQL wins hands down on cost and ease of installation. Its raw performance for simple things ain't shabby either. (On complex queries, Oracle wins again.)

If you want a more detailed comparison, Barry is the one to talk to.

Cheers,
Ben
I have come to believe that idealism without discipline is a quick road to disaster, while discipline without idealism is pointless. -- Aaron Ward (my brother)
Post #258,265
by static
Picture of static
6/8/06 9:35:59 PM
Reply
New Oh I have little doubt about that.
However, I neglected to mention I was limiting my comment to their brand of SQL. :-)

I'm beginning to think we're coming up against some of MySQL's more subtle and complex limits. I wish I could engineer to time to try my app in PostGres... Oracle is not an option for us, financially.

Wade.
"Insert crowbar. Apply force."
Post #258,268
by ben_tilly
6/8/06 10:03:53 PM
Reply
New Oracle is picky but...
its brand of SQL is more flexible once you get used to it.

That is, there are not so many shortcuts. But you can do more with it. (Though MySQL is one by one removing its limitations. There is no question that Oracle is not the future of databases.)

Cheers,
Ben
I have come to believe that idealism without discipline is a quick road to disaster, while discipline without idealism is pointless. -- Aaron Ward (my brother)
     Left Outer Join question - (ChrisR) - (20) - June 7, 2006, 10:26:29 PM EDT
         One approach - (ben_tilly) - (6) - June 8, 2006, 01:13:51 PM EDT
             Some variation on MIN... - (ChrisR) - (3) - June 8, 2006, 11:10:15 AM EDT
                 It probably will not optimize - (ben_tilly) - (2) - June 8, 2006, 01:27:27 PM EDT
                     Yep, took forever to run. - (ChrisR) - (1) - June 8, 2006, 02:00:51 PM EDT
                         Nothing non-standard about that - (drewk) - June 8, 2006, 02:40:14 PM EDT
             Pre indentation - (ChrisR) - (1) - June 8, 2006, 02:02:57 PM EDT
                 Bug, indentation can be lost during edits (new thread) - (ben_tilly) - June 8, 2006, 02:18:49 PM EDT
         Does SQL Server support "DISTINCT ON"? - (drewk) - (12) - June 8, 2006, 08:55:49 AM EDT
             That is really what I need! - (ChrisR) - June 8, 2006, 10:56:50 AM EDT
             The more readable version is invalid (at least in Oracle) - (ben_tilly) - (10) - June 8, 2006, 01:12:25 PM EDT
                 Hmm, both Postgres and MySQL support the same non-standard? - (drewk) - (9) - June 8, 2006, 01:49:01 PM EDT
                     Can you please help me find mine? - (folkert) - June 8, 2006, 02:04:49 PM EDT
                     That is a MySQL shortcut - (ben_tilly) - (7) - June 8, 2006, 02:14:38 PM EDT
                         Not surprising - (drewk) - (2) - June 8, 2006, 02:42:46 PM EDT
                             Or you didn't double-check enough - (ben_tilly) - (1) - June 8, 2006, 02:50:14 PM EDT
                                 Also possible - (drewk) - June 8, 2006, 04:17:32 PM EDT
                         I've encountered that problem. - (static) - (3) - June 8, 2006, 08:48:27 PM EDT
                             Justifiable arrogance in many cases - (ben_tilly) - (2) - June 8, 2006, 09:18:47 PM EDT
                                 Oh I have little doubt about that. - (static) - (1) - June 8, 2006, 09:35:59 PM EDT
                                     Oracle is picky but... - (ben_tilly) - June 8, 2006, 10:03:53 PM EDT

Go back to making claims about Wookies and Endor.
123 ms