DEANO.ME

mysql

 

php

There is a mobile optimized version of this page, view AMP Version. I consider myself a seasoned PHP Web Developer, with over 10 years working in the field and with all the care and attention I’ve given Web Development over those 10 years it frustrated me recently to come across a problem that a client […]

 

opencart

There is a mobile optimized version of this page, view AMP Version. In August 2014 I started an article on improving the speed and performance of your OpenCart store by improving your OpenCart database indexing, shockingly it appears OpenCart did not set required indexes that are vital for larger OpenCart stores. MySQL uses indexes to […]

 

Are you looking to simply duplicate existing rows in your MySQL table? I needed to do this recently for a database I had for a project I was developing, I wanted to duplicate the data in the database to about 10,000 rows to test response times of SQL and perform optimization on the system.

 

There is a mobile optimized version of this page, view AMP Version. Apologies for the downtime, I’m officially a dumbass… Changed the MySQL database username/passwords last night and forgot to update the WordPress connection information. On another note, we did experience some downtime Monday also, this was due to a technical fault with the MySQL […]