The Benefit Of Using Indexes In Database Tables

It takes time for a database to search through row upon row of information and find specific values. It’s a task made more difficult as rows of data are removed and new ones are added. Over time, data can be stored more randomly than you would think or like. Indexes are a way to overcome this and to help make it quicker to find values in database tables.

Continue reading

The End of View Source?

I remember when I first learned how to build websites. I would read books after coming home from my job testing software and I would build the simplest of web pages to practice what I read about. A few nights a week I took continuing education courses on my way toward earning a certificate in website design or something to that effect.

Continue reading

MySQL Configuration Tweaks To Improve Site Performance

Sometimes the defaults that come with a product are exactly what you want. Other times they aren’t and you need to make a few changes. When it comes to MySQL, you’ll probably get along just fine if you never change a thing, but you can probably do better than the defaults with a few tweaks.

Continue reading

An Introduction to MySQL Database Performance

It takes time to open a connection to a database, make a query, have the database find the requested data, and send it back to the file that made the request. That’s true even for very simple queries. The time depends on how the database is configured, the hardware on the server, how the data is stored in the tables being searched, and of course, how well the queries have been written.

Continue reading

Think Longer Term to Be More Productive With Creative Work

Last week I told you how I break down my writing process and how I think about the different steps in the process in terms of the energy level and focus I need in order to work on them. I also told you how I use these energy levels to manage my tasks for the day.

Continue reading