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 [...]

Import Excel Data to SQLite DB Using Java

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

Prerequisites: SQLite, Java, Database What it covers?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 a [...]