Some ideas regarding to database performance (General)
Hi,
(my skill does not reach up to yours, but i do my best...)
the combination of
Hoster: IONOS Germany
DB: MariaDB 10.6
PHP: 8.1
Forum: 20220803.1
and this php script as a dummy test:
?
$xtext="CREATE PROCEDURE Test5 ()
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
BEGIN
select count(*) from mlf2_settings;
END
; "
?>
works to create a SP.
I put an include at the end of includes/admin.inc.php (just before th subtemplate is called)
for this
and a
$result = mysqli_query($connid, $xtext);
as next.
Using phpmyadmin shows syntax differences between php and the frontend of phpmyadmin.
Testing SQL code in phpmyadmin, you have to use the Delimiter field below of the input field.
Works, but only for testing.
Best
Andi