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

Welcome to IWETHEY!

New What I mean is we'll keep having one-off events
We've never done this event for this client at this venue before.

I find it hard to believe the things that matter to query performance would change so radically from event to event. Volume should be the major factor, so if we handle $x TPS we should be good for anything < $x. That doesn't seem to be true.
--

Drew
New Absolutely not
TPS is total volume. Which nothing to do with data skew. New or changing field contents can dramatically change which indexes to use or how to use them, or to use them at all, which modifies query plan.
New This.
The larger the data load, the bigger the potential change in index distribution.
Regards,
-scott
Welcome to Rivendell, Mr. Anderson.
     How much impact should automatic query plan optimization have? - (drook) - (9)
         Realistic volume, perhaps? - (scoenye)
         You should automatically collect stats on an ongoing basis - (crazy) - (6)
             One-off event - (drook) - (5)
                 Isn't that "one off" stuff... - (Another Scott)
                 Huh? - (crazy) - (3)
                     What I mean is we'll keep having one-off events - (drook) - (2)
                         Absolutely not - (crazy) - (1)
                             This. - (malraux)
         I've not worked with a DB that needed that to happen. - (static)

I knew it as soon as you told me.
91 ms