Is your feature request related to a problem? Please describe.
Feedback from some MySQL/MariaDB users is that they are not familiar with stored procedures and the potential benefits. Implementing a client-only SQL/No stored procedure option would allow MySQL/MariaDB users to explore the differences between application-side and server-side logic.
Describe the solution you'd like
Implement a no stored procedure option for MySQL/MariaDB that when selected replaces stored procedure calls with the same SQL called from the HammerDB client.
Describe alternatives you've considered
Alternative is the existing stored procedures.
Additional context
Initial trial investigation suggests that the existing stored procedure implementation is appx 20% faster than the client-side SQL implementation, with time spent in particular in the network layer however, this feature will allow users to explore and understand the difference.
Is your feature request related to a problem? Please describe. Feedback from some MySQL/MariaDB users is that they are not familiar with stored procedures and the potential benefits. Implementing a client-only SQL/No stored procedure option would allow MySQL/MariaDB users to explore the differences between application-side and server-side logic.
Describe the solution you'd like Implement a no stored procedure option for MySQL/MariaDB that when selected replaces stored procedure calls with the same SQL called from the HammerDB client.
Describe alternatives you've considered Alternative is the existing stored procedures.
Additional context Initial trial investigation suggests that the existing stored procedure implementation is appx 20% faster than the client-side SQL implementation, with time spent in particular in the network layer however, this feature will allow users to explore and understand the difference.