John Dao
Forum Replies Created
-
Forum: Plugins
In reply to: [Genesis Blocks] Will there be WPML support?WPML supports some kind of XML traversing of Gutenberg blocks, something along the lines of as an example from their documentation. The type below core/image is what’s registered in the the Gutenberg block API, is there something similar in the Genesis plugin?
<wpml-config>
<gutenberg-blocks>
<gutenberg-block type=”core/image” translate=”1″>
<xpath>//figure/figcaption</xpath>
<xpath>//figure/img/@alt</xpath>
</gutenberg-block>
</gutenberg-blocks></wpml-config>
Forum: Plugins
In reply to: [WooCommerce] Database Growing – _wc_sessionI’ve been investigating this issue for months, our wp_options table is in the gigabytes now.
The problem is WooCommerce isn’t cleaning up after itself, and it’s related to the cron job not running. So easiest way to check is if you can run wp-cron.php from the outside (http), in my case we had accidentally blocked the port.
Apologies for the late reply – can you confirm if WPMP does update the WP Options table?
Is this sql query related to WP MP?
UPDATE
wp_optionsSEToption_value= ‘172755726’ WHEREoption_name= ‘wpmp_switcher_hits_desktopUPDATE
wp_optionsSEToption_value= ‘172755726’ WHEREoption_name= ‘wpmp_switcher_hits_mobileI’m also confused why it would initiate so many database writes, when a WooCommerce setting (any setting) is saved, and WooCommerce only.
When i de-activated WPMP (de-active via Plugins menu), the database writes still occur. Do i need to remove the entire plugin from the file system?
Thanks for any help.
Forum: Plugins
In reply to: [Better WordPress Minify] admin-barHi Khang Min – i’m having the same issue, running WordPress 3.9 and the admin bar shows up at the bottom of the site whether i’m logged it or not.
Hi Nicola,
In this case that seemed to have been the issue – of course at the time i wasn’t sure, so I whipped out load-testing tools, PHP profilers and mysql debuggers lol.
But really all i had to do was to normalize the scope of the query from 500 days (might as well be infinite) to something reasonable like 50-100 event objects.
Thanks for your quickly reply, and best of luck.
Hi Nicola,
I’m running the latest version of pro, and the site seems to bog down when I have the sidebar widget fetch events in the past “500” days. Changing this to only the last 30 events drastically helps, but obviously it’s a compromise.
I have 169 events in the DB with W3 Total Cache already running, so not that many at the moment. For the time being this seems to be a good stop-gap measure.
Forum: Plugins
In reply to: [Timely All-in-One Events Calendar] MAX CPU UsageThanks for your quick reply Nicola – that makes sense to me because whatever is happening, the number of php seem almost exponential with the number of events, and yet the DB load remains quite manageable.
I had pages that pulled 500 event objects and that was a real problem, when i reduced the number of objects to 50 then it was fine.
So the link you sent is for the free standard version, what about the pro version?
Cheers,
LuyenForum: Plugins
In reply to: [Timely All-in-One Events Calendar] MAX CPU UsageBeen researching this issue for a client who’s using the pro version of this plugin. Whether 1 event or 200 events are displayed in a sidebar, it overloads the CPU and calls the apply_filters() function around 2000 times on each page.
I’m trying to track down by this is happening, as the bottle-neck appears to be entirely in code, and no front-end or SQL performance is affected.
Forum: Reviews
In reply to: [wp-FileManager] Good plugin for admins / publishers.Thanks for your plugin first of all –
I understand that it shows all files in your filesystem that makes total sense.
But i don’t understand why it’s showing (logged in as admin) all the files in my sidebar when i haven’t enabled the widget for it?
Forum: Fixing WordPress
In reply to: Need advice: Trying to import posts and terms as XML filesThanks Seacoast – i have a general idea what to do, just lacking the precise methodology.
Should i do the join in MS SQL Server first or is there a way to merge the exported XML files based on some relationship criteria?
This is the part i’m not sure about, which way is better, and if the latter what tools are used.
Thanks again.
Forum: Fixing WordPress
In reply to: Need advice: Trying to import posts and terms as XML filesA .NET CMS called Ektron, so running on MS SQL Server – could i do a JOIN in SQL and merge the two tables in question together? Would that make sense?
Forum: Everything else WordPress
In reply to: Best practices: Importing CSV data into WordPressreposting
Forum: Everything else WordPress
In reply to: Best practices: Importing CSV data into WordPress*bump
No Edwin, thank *you* for writing this plugin!