MySQL provides several commands for optimizing a database. Here are some of the most commonly used commands we use to optimize and improve performance in a database: ANALYZE TABLE: This command analyzes the table and updates the table statistics. It helps in optimizing the table and improves the query performance. OPTIMIZE TABLE: This command optimizes the table and...
Most servers run a fairly default configuration with PHP. In addition, there are a lot of bad programming practices that we see. Here are some tips to harden and secure PHP: Keep PHP Updated: Keeping PHP updated to the latest version can help patch security vulnerabilities and reduce the risk of attacks. Use an automated task for this or an industry standard control...
Tech Profile: Shopify + custom PHP / CAKE for installment and re-occurring billing. We were brought in to create a payment installment system that allowed orders to be place, fulfilled and subsequently billed for a limited number of re-occurring payments. We worked with Shopify Plus and Authorize.net as a solution combination for making this feature a reality. We...
As a development firm located just outside of Seattle, we have a large body of experience working with the CAKEPHP MVC framework. If you have never used CAKEPHP it is an open-source, rapid development PHP framework. It provides a solid foundation and structure for frontend developers and programmers to create robust web applications. While we work with a number of...
There comes a time when you really need to increase the amount of time it takes before your server stops a particular PHP process from continuing. This is called PHP session "timeout". Under normal conditions you want to keep these values low so your connections are as efficient as possible. These limits are also in place to prevent poorly written scripts from...
Securing Drupal, regardless of the version you are working with, is not that difficult. Security, as a baseline, is always a multi-layered exercise. Many clients do not understand that you have to work on securing everything that makes up your website - from server operating system all the way to the application layer. This post is not going to go into server...
So, here's something that comes up all the time - you have a sub-directory you want to exclude from a global .htaccess redirect. Often this is due to installing another application within the document-relative paths of an existing website or web application. e.g. You want to install a copy of WordPress within an existing Drupal website. or maybe you have an...
One of the problems that you may have while upgrading CS-Cart is that the upgrade inexplicably fails during the upgrade process. If you are lucky, you will get a error trace umped to a file or the screen. If not, it may just silently fail in the background or freeze up. This is certainly no fun. There's a number of different carts that experience this, so it is not...
What causes high CPU in Searchandise and CS-Cart? We've noticed an issue where Searchandise eats up a large amount of CPU. In some instances, when you turn on Searchandise from the add-ons it spins the CPU up to a point where it can even crash. This is heavily dependent on how many products you have in your catalog. It can be barely noticeable on CS Cart catalogs...
