Although relational databases are a powerful tool, they don’t fit in well in situations where many, many joins are required. The execution time becomes very high as soon as you do 3 or 4 joins on tables with tens...
Tag - database
Vladimir MartonDatabase Tutorial – Single Connection vs Connection Pool
In the previous article from the Best Database Practices series I explained the importance of using PreparedStatements. I also stated that using PreparedStatements in connection pool might be tricky. Today, I will...
Database Tutorial – Statement vs PreparedStatement
The first article of the series Best Database Practices will explain what Statements and PreparedStatements are, what is the difference between the two, performance comparison and simple code examples. In the world of...
Import/export tables or databases to .sql in MySQL (examples)
This tutorial will cover basic import and export terminal procedures in MySQL. Each of the procedure is explained through an example. All of the export commands are also available remotely, all you have to do is to...