Index WP MySQL For Speed

Consider using his plugin by default:
https://wordpress.org/plugins/index-wp-mysql-for-speed/

You only have to run it once, to create better indexing keys on the database tables, which in my eyes should be default in WordPress.
Unbelievable what I see in speed performance so far!

(Found this plugin actually by following the steps in this blog article for a client.)

But wait, there is more!
https://www.plumislandmedia.net/wordpress/performance/optimizing-wordpress-database-servers/

WordPress Constants

Something I wanted to keep for reference.
See the source here: https://wppb.me/wordpress-constants

WordPress offers multiple ways to configure and customize your site, from the admin panel to hooks (filters and actions). However, one of the most powerful and often overlooked methods is through PHP constants. These constants provide developers with fine-grained control over various aspects of WordPress functionality.

Continue reading WordPress Constants

WP_MEMORY_LIMIT or WP_MAX_MEMORY_LIMIT ?

the more you know

By default, WordPress enforces a memory limit of 40 MB. This means a single PHP script is allowed to use up to 40 MB of RAM. In certain cases, you may need to increase WordPress’ memory limit to run heavier plugins like WooCommerce or bbPress. To increase WordPress’ memory limit, you can define WP_MEMORY_LIMIT in your wp-config.php file using the line below.

define( 'WP_MEMORY_LIMIT', '256M' );

The setting above will allow WordPress to use up to 256 MB of RAM for each script, as long as the memory_limit setting in your php.ini file is 256 MB or greater. As is often the case with computing resources, setting a higher memory limit doesn’t necessarily increase the performance of your WordPress site. Since WP_MEMORY_LIMIT controls memory allocation PER SCRIPT, it’s actually in your best interest to set it as low as possible to reduce the chance of a rogue script saturating the RAM in your server.

Sometimes, it’s a good idea to tailor WordPress’ memory allocation separately for the frontend and backend. That’s where WP_MAX_MEMORY_LIMIT comes in. WP_MAX_MEMORY_LIMIT allows you to set a different memory limit for WordPress’ administration dashboard. This is useful because certain administration tasks require more RAM. Below is an example of how you can use WP_MEMORY_LIMIT and WP_MAX_MEMORY_LIMIT together.

define( 'WP_MEMORY_LIMIT', '64M' );
define( 'WP_MAX_MEMORY_LIMIT', '256M');

The setting above will allocate up to 64 MB of RAM per PHP script for processes spawned from WordPress’ frontend, while administration-related scripts from the backend dashboard will be able to use up to 256 MB of RAM.

Cannot find wrapper assembly for type library “ADODB”

Happy new year and Happy coding!
Using Visual Studio 2022 on Windows 11 with the latest updates to 24H2, started giving the following errors when trying to compile an older project:

The "ResolveComReference" task returned false but did not log an error.
Cannot find wrapper assembly for type library "ADODB". Verify that (1) the COM component is registered correctly and (2) your target platform is the same as the bitness of the COM component. For example, if the COM component is 32-bit, your target platform must not be 64-bit.

So, you Google a bit and find this, but don’t do that!
In my case, the following article helped, or just a comment from it “Mine was resolved by removing the reference to “Microsoft HTML Object Library” and adding it again in the project.“.

  • In solution Explorer, open ‘My Project’
  • Go to the tab ‘References’
  • Find your mentioned library on the top, in my case, ‘Microsoft ActiveX Data Objects 2.8 Library’ with some ‘ADODB.dll’ in a system32 folder.
  • Click the ‘Add’ button, tab COM > Type Libraries, and find your library, it should be checked.
  • UNCHECK it, and OK the popup
  • Repeat: Click the ‘Add’ button, tab COM > Type Libraries, and find your library, now unchecked.
  • CHECK it, and OK the popup
  • Save everything and try to compile again.

That should work.
If not, so sorry, but it did for me…

Have a nice day!