[MDEV-13489] benchmark stored routines Created: 2017-08-10  Updated: 2017-08-10

Status: Open
Project: MariaDB Server
Component/s: Stored routines
Fix Version/s: None

Type: Task Priority: Major
Reporter: Axel Schwenke Assignee: Axel Schwenke
Resolution: Unresolved Votes: 0
Labels: None


 Description   

Define workloads suitable for testing the performance of stored routines. Ideally the workload would be independent of the performance of storage engines, to minimize the effect of performance changes outside stored routines parser on the results.
For testing the Oracle style PL/SQL in MariaDB 10.3, at least some routines must be implemented in both dialects to allow a comparison.

 Comments   
Comment by Axel Schwenke [ 2017-08-10 ]

A fibinacci function has been used for such tests in the past:
http://mtocker.livejournal.com/45222.html
http://www.twiedmann.de/sqlbackstube/mysql_procedure_performance

Generated at Thu Feb 08 08:05:59 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.