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 / I heard 8% the other day for MySQL/InnoDB
Post #252,317
by dws
4/15/06 1:37:39 AM
Reply
New I heard 8% the other day for MySQL/InnoDB
But no authorative reference was given.
Post #252,329
by broomberg
4/15/06 11:00:22 AM
Reply
New Percentage differences that close are really just a SWAG.
Depends on record size, speed of disk (sequential VS seeking), RAID type, how much processing you will do in between each record, etc.

There is no way any of the "experts" would be willing to bet a number against a database (fully populated) unless they's tested it.
     subtracting dates inside rdbms as opposed to outside - (boxley) - (18) - April 10, 2006, 02:16:44 PM EDT
         Indexes key to efficiency - (ChrisR) - (17) - April 10, 2006, 02:25:30 PM EDT
             that runs faster by eyeball :-) thx! -NT - (boxley) - April 10, 2006, 02:34:34 PM EDT
             Lotta people make that mistake. - (static) - April 11, 2006, 08:27:59 AM EDT
             Indexes are only better if you're accessing under 7%... - (ben_tilly) - (14) - April 11, 2006, 11:40:07 AM EDT
                 It's 5% now. - (admin) - (11) - April 11, 2006, 11:42:37 AM EDT
                     Source? - (ben_tilly) - (10) - April 11, 2006, 12:13:34 PM EDT
                         My SQL tuning class instructor. :-D -NT - (admin) - (9) - April 11, 2006, 12:40:55 PM EDT
                             Is it coincidence that we both took that class recently? -NT - (ben_tilly) - (8) - April 11, 2006, 12:52:43 PM EDT
                                 Dunno. - (admin) - (7) - April 11, 2006, 03:17:39 PM EDT
                                     There was a cost-based optimizer in Oracle 8 as well - (ben_tilly) - (6) - April 11, 2006, 05:07:40 PM EDT
                                         I'd appreciate a list if you can take the time. - (admin) - (5) - April 11, 2006, 05:35:10 PM EDT
                                             Hmm... - (ben_tilly) - (4) - April 11, 2006, 07:04:48 PM EDT
                                                 Thanks. -NT - (admin) - April 11, 2006, 11:06:58 PM EDT
                                                 OK, here's a real bug, just encountered - (ben_tilly) - (2) - May 4, 2006, 10:10:54 PM EDT
                                                     I'll have to give that one a whirl. -NT - (admin) - (1) - May 5, 2006, 08:18:31 AM EDT
                                                         It can probably be simplified further... - (ben_tilly) - May 5, 2006, 11:01:32 AM EDT
                 I heard 8% the other day for MySQL/InnoDB - (dws) - (1) - April 15, 2006, 01:37:39 AM EDT
                     Percentage differences that close are really just a SWAG. - (broomberg) - April 15, 2006, 11:00:22 AM EDT

Like many lawyers, he's overly fond of argument, even when in agreement. Not that anyone here would be into that...
157 ms