Re: Stored Procedures in C++? (and direct access to storage engine API)

[Kazuho Oku]

Hi,

Thank you for your quick response!  After looking at the branch, I
tried using UDFs for the purpose (I know its nasty), and it seems to
work fine (over 10x performance boost).
http://labs.cybozu.co.jp/blog/kazuhoatwork/2008/06/optimizing_mysql_performance_u.php

2008/6/11 Brian Aker <brian@stripped>:
> Hi!
>
> You should look at Antony Curtis'es tree for this sort of support. Him and
> Eric Herman have been working on this sort of API for a while now.
>
> Cheers,
>        -Brian
>
> On Jun 10, 2008, at 9:02 PM, Kazuho Oku wrote:
>
>> Is it possible to write stored procedures in C++?  Or is anybody
>> working on something alike?
>>
>> What I am looking for is a way to implement stored procedures in C++
>> that can be loaded / unloaded dynamically, like UDFs or pluggable
>> storage engines.  And within the stored procedure, I would like to
>> call the methods of storage engines directly, so that the overhead of
>> SQL parsing and building execution plans can be bypassed.
>>
>> For example, it is difficult to implement a fast SQL query to obtain a
>> timeline (like that of twitter, please see see
>>
>>
> http://labs.cybozu.co.jp/blog/kazuhoatwork/2008/06/implementing_timeline_in_web_s.php
>> for more detail).
>> IMHO, direct access to storage engine APIs would be of great help in such
>> cases.
>>
>> --
>> Kazuho Oku
>>
>> --
>> MySQL Internals Mailing List
>> For list archives: http://lists.mysql.com/internals
>> To unsubscribe:
>>  http://lists.mysql.com/internals?unsub=1
>>
>
> --
> _______________________________________________________
> Brian "Krow" Aker, brian at tangent.org
> Seattle, Washington
> http://krow.net/                     <-- Me
> http://tangent.org/                <-- Software
> _______________________________________________________
> You can't grep a dead tree.
>
>
>
>



-- 
Kazuho Oku