Hi Prafulla, I believe that Drizzle is open to most changes if they provide enough benefit. We're not so much worried about changing or not changing as we're interested in getting better and faster. If something really provides amazing performance, it should get attention.
You might want to speak with Brian in IRC or email if you're thinking of making major changes. He'd be able to help you figure out a good plan of attack and whatnot. You might also want to speak with Padraig as he has an interest in optimizer work. Hopefully anyone with additional information or guidance can chime in here too as I'm still a bit new. However, please hack away. Given what you've done with the optimizer so far, I'd be interested in seeing what you can cook up : ) Thanks, Patrick On Fri, Aug 13, 2010 at 3:07 AM, Kristian Nielsen <[email protected]>wrote: > Prafulla Tekawade <[email protected]> writes: > > > They had "vectorised" query operators (All operator would execute > > on a batch of tuples rather than a single tuple.) It gave really lot > > of good performance improvement because it made better use of > > CPU cache. > > We can have something like that in drizzle. > > This makes me think of BKA, "batch key access" in MySQL. This is a feature > where the optimiser can send batches of key values into the storage engine, > and > the storage engine will return batches of matching tuples. This is used eg. > in > nested-loop joins to work on batches of tuples at a time. > > Not sure if this is what you had in mind though. > > I'm actually also not sure which tree this currently exists in, if any, > though > I know it exists (I re-wrote the NDB handler to use the new BKA interface > at > some point). Could be that it was in MySQL 6.0 (and so perhaps even in > Drizzle), but I vaguely recall that it was never in main MySQL 6.0, only a > 6.0 > feature tree. It might be in MariaDB 5.3. A question to the optimiser guys > in > #maria on FreeNode will probably provide a clear answer in case of > interest. > > - Kristian. > > _______________________________________________ > 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
