huge problem with database size !

@mlh17 – Hmm, how many popups do you have created? Also what was the DB size after deletion, 23k rows isn’t actually that much in terms of space generally and really shouldn’t cause a huge slowdown, at least on my own servers.

Just thinking though, it may be post revisions that have stored meta. Simply cleaning out revisions from time to time would take care of that, plenty of plugins to do that for sure.

Sorry, I forgot to give the link to the website:
https://www.livingfromyoursoul.org
(I activated the plugin temporarily again.)

And here is the script I used to have a form of Stefano Lissa’s newsletter-plugin in the popup:

<script type="text/javascript">// <![CDATA[
if (typeof newsletter_check !== "function") {
window.newsletter_check = function (f) {
    var re = /^([a-zA-Z0-9_\.\-\+])+\@(([a-zA-Z0-9\-]{1,})+\.)+([a-zA-Z0-9]{2,})+$/;
    if (!re.test(f.elements["ne"].value)) {
        alert("The email is not correct");
        return false;
    }
    if (f.elements["nn"] && (f.elements["nn"].value == "" || f.elements["nn"].value == f.elements["nn"].defaultValue)) {
        alert("The name is not correct");
        return false;
    }
    if (f.elements["ns"] && (f.elements["ns"].value == "" || f.elements["ns"].value == f.elements["ns"].defaultValue)) {
        alert("The last name is not correct");
        return false;
    }
    if (f.elements["ny"] && !f.elements["ny"].checked) {
        alert("You must accept the privacy statement");
        return false;
    }
    return true;
}
}
// ]]></script>
<p><!--</p>
<div class="newsletter3 newsletter-subscription"> --></p>
<form action="https://www.livingfromyoursoul.org/wp-content/plugins/newsletter/do/subscribe.php" method="post">
<table border="0" cellspacing="0" cellpadding="3"><!-- first name -->
<tbody>
<tr><th>Name</th>
<td><input class="newsletter-firstname" name="nn" required="" size="30" type="text" /></td>
</tr>
<!-- email -->
<tr><th>Email</th>
<td align="left"><input class="newsletter-email" name="ne" required="" size="30" type="email" /></td>
</tr>
<tr>
<td class="popuprightcode-td-submit" colspan="2"><input class="popuprightcode-submit" type="submit" value="Subscribe" /></td>
</tr>
</tbody>
</table>
</form>

Hope, these information help.
Thanks.

@mlh17 – I will add an issue to our github to find a solution. I see some on our site as well, not nearly as many as you found but over 1800. The keys are mostly checkboxes that are unchecked and extension fields that are unfilled. Examples are when auto open is not enabled its still storing a meta key for each auto open setting.

Will look into better way of storing that info.

https://github.com/PopupMaker/Popup-Maker/issues/62

@daniel – Thanks for your reply.
A friend of mine, a database specialist, helped me with cleaning, and he said the empty entries of popup ‘occupied’ about 12 MB in the database.
Thanks a lot for the hint with the revisions – I will check this; perhaps this is the main problem – I will report.
kind regards
Markus

If your using phpMyAdmin it actually has a size stat, should be pretty easy to determine exact size next time ??

It likely is revisions though.

Gonna work on it for future versions.

@ Daniel
I did the deleting of old revisions and some other optimization, and now the stats in the database show a size of 13 MiB overall – so, everythings seems to be fine again ??
Thanks a lot for your support !! I will check the database from time to time,
and Popup Maker is running again ??

sunny greetings from Berlin

Markus

@mlh17 – Awesome, glad to hear it. I will be making many optimizations in future versions to reduce this, including making revisions optional.

Please take a moment to rate and review the plugin and or support.