Roy Lyseng wrote:


Jay Pipes wrote:
Roy Lyseng wrote:
Brian,

do you have a breakdown of the cost of the various modules in a bread-and-butter query? I am most interested in SELECT queries with small result sets...

By "modules" do you mean runtime vs optimizer vs. protocol (send) or do you mean JOIN::prepare vs. JOIN::optimize vs JOIN::execute?

As far as you can go :) Breaking up into preparation, execution, storage engine and protocols would be a good start, but the more information, the better... Preparation could again be broken up into lexer, parsing, translation (JOIN::prepare) and optimization.

Understood. :) Brian and I are working on some callgrind pieces to the Drizzle automation suite which would run callgrind profiles on each revision for basic queries, so that we can compare # ops in the call stacks for each revision. I'll keep you updated as to where the grind files end up being pushed to so you can pull one into KCachegrind for analysis....

Cheers!
Jay

Thanks,
Roy

Cheers!

Jay

Thanks,
Roy

Brian Aker wrote:
Hi!

On May 14, 2009, at 10:05 AM, Kay Röpke wrote:

Next I'll try to get it working for drizzle

Awesome :)

I was just going through the call stack last night for the Lexer and was amazed at how inefficient the thing is. That thing is chewing up a ton of CPU...

Cheers,
    -Brian

_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help   : https://help.launchpad.net/ListHelp

_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help   : https://help.launchpad.net/ListHelp


_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help   : https://help.launchpad.net/ListHelp


_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help   : https://help.launchpad.net/ListHelp

Reply via email to