Tag - SQL

Banner for Query optimization blog

SQL Query Optimization to Improve Performance – Devstringx

Problem High CPU utilization and CPU memory consumptionThe performance plays a vital role in our application to run our online business smoothly, doing  SQL query optimization is tricky, but necessary practice for database professionals. It requires looking at various collections [...]

Import Excel Data to SQLite DB Using Java

How to Import Excel Data to SQLite DB Using Java | Devstringx

Prerequisites SQLite, Java, Database What Does It Cover?Creating and closing database connection (JDBC) Creating dynamic schema Creating a table and deleting table values Reading data from excel Importing excel data to DBHow does it work?To execute the SQL queries using java, we need to establish [...]