I've used the excellent Yet Another Related Posts Plugin (YARPP) for about a year-and-a-half now on various client websites. Overall, I've found that it works great and has a responsive author who cares about updating and performance issues. Why this post then? Because after experiencing deadly slow post updating and post saving on a client site over the span of more than 60 days, we were finally able to track down that YARPP was causing saving or updating posts and pages to take more than a … [Read more...]
MySQL
Yet Another Related Posts Plugin (YARPP) and Site Slowness
August 15, 2011 By Aaron Brown
Filed Under: WordPress Development Tagged With: MySQL, Performance, Speed, Updating Page, Updating Post, wordpress, YARPP, Yet Another Related Posts Plugin
Convert MS Access Date to Unix Timestamp to MySQL Timestamp
June 9, 2011 By Aaron Brown
I came across a problem today where I needed to convert a date in an MS Access Database to a MySQL timestamp using PHP. The solution was pretty easy, but took some thinking through. Here is the answer to save you some time if you need it. Get the date from your MS Access database. If you're using PHP to do this, you'll likely use the odbc_exec($connection, $query) function and the odbc_fetch_array() function. Convert the MS Access date format into a UNIX Timestamp using PHP's strtotime() … [Read more...]
Filed Under: Web Development Tagged With: database, handling dates, MS Access, MySQL, MySQL Timestamp, PHP, PHP Date, Unix Timestamp