C++ vs Python For Loops

Kit Oster — Sat, 11 Mar 2023 21:07:48 +0000

The very first programming language I interacted with was C++, and that became the language through which I thought about loops. Seeing my first Python for loop was a scary experience, which was surprising as I had always heard Python described as friendly!

Let's take a look at the same loops in C++ and Python 3. The following C++ and Python code will both loop through an array of three fruits.

C++

Python

Both of these will output the following:
Apple
Banana
Cherry

Some key differences here are that we have to explain what we want to do a little bit more with C++. Statement 1 is used to set a variable before the loop starts (int i=0), statement 2 will gives the condition for the loop to run, and statement 3 increments or decrements the variable. Python is much less wordy.

To print the numbers 0 through 5, all we would have to do in Python is the following:

And this will output
0
1
2
3
4
5

Whereas in C++, we would do something like this:

int main() {
for (int i = 0; i < 6; i++) {
cout << i << "\n";
}
return 0;
}

Though switching to Python felt like a big change at first, I soon realized how intuitive it is. Python is flexible, powerful, and easy to learn, making it a great choice for first-timers or experienced programmers looking for a change of pace.

What is Database Tuning?

Kit Oster — Mon, 06 Mar 2023 22:22:04 +0000

Database tuning is the process of optimizing your database. This process covers all parts of the system - hardware and software - to keep query response times down and keep things running smoothly and efficiently. Being on top of this improves the database's speed, reliability, and scalability.

Starting off on the right foot with a database is important. The database should be well-planned and efficient, and database tuning should be a routine practice.

So - what can we do to optimize our database?

There's many options! Note: This list is general, and tuning practices vary between databases.

For starters, we can make sure we're allocating enough memory to our database, as lack of memory can cause performance issues. In a similar vein, investing in a powerful CPU can go a long way for your database.

The improved execution of queries is one of the primary goals of database performance tuning. This involves removing calculations in JOIN and WHERE clauses, checking for indexes, and working with the smallest data set needed. Writing poor queries can result in database performance problems. Because databases can be so huge, we shouldn't use leading wildcards or SELECT *.

Tuning scripts can also be a great starting point. For example, Mysqlreport takes SHOW STATUS and turns it into a more user-friendly report to let you know how well MySQL is running. MySQLTuner assists with configuration and makes recommendations for better performance. Though these scripts are made for MySQL, scripts exist for other Database Management Systems too.

Database tuning is important for every database, and includes hardware and software considerations such as memory and CPU. Optimized queries and the use of scripts will help you keep your database running efficiently and reliably.

Thanks for reading,

Kit

DEV Community: Kit Oster

C++ vs Python For Loops

What is Database Tuning?