But doing it your way means the field can be indexed.
Ain't much more frustrating for a DBA is a developer who doesn't understand why his queries are badly written...
Wade.
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