WL#3431: ndbapi stored procedures
Affects: Benchmarks-3.0 — Status: Un-Assigned — Priority: Medium
Currently a lot of sql processing is painfully slow due to mysqld query execution algorithms. This make some (a lot) of customers use ndbapi instead. This however forces them to have "separate" applications environment etc... and quite a lot of hassel. This idea is that one make a "hot" query/transaction into a stored procedure that calls a udf that implements the query/transaction using ndbapi. This will enable a simpler/cleaner way for users to combine sql/ndbapi How to impl. this i dont know really as i dont know the udf-interface. But an addition will have to be that a udf can get access to a NdbTransaction. (It is not currently possible to do this as a UDF. UDFs do not have access to the current transaction, or the open tables, or even the current thread. So it seems to me that it would require a new variety of plugin with a newly designed interface. - JD)
Copyright (c) 2000, 2017, Oracle Corporation and/or its affiliates. All rights reserved.