Home » SQL

Tag - SQL

Banner for Query optimization blog
06 Aug

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

By Development , , , Comments Off
Read more...
Import Excel Data to SQLite DB Using Java
07 Oct

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

By Software Testing, Testing , , , , Comments Off
Read more...