Database Performance

Adalat Khan

Hi,

How to increase the speed and performance of a very big database?. Suppose we have a database in which each table has millions of records so how we can implement techniques or rules to improve its speed and performance?. Which are the best techniques and rules?.

Thanks.

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sagar Lad5y ago
Hi Adalat,

Check this blog for more information : https://www.eversql.com/5-easy-ways-to-improve-your-database-performance/
Ravinder Sharma5y ago
Hey,
You can follow this

https://www.c-sharpcorner.com/UploadFile/ff2f08/tips-to-improve-sql-database-performance/
Puneet Kankar5y ago
Hi Adalat,

Please go through the below link it is given many ideas about the performance tuning of the database.

https://www.quest.com/community/blogs/b/database-management/posts/10-database-performance-tuning-best-practices

https://www.toptal.com/sql-server/sql-database-tuning-for-developers

The point which helps us for increase database performance.

Keep statistics up to date

Don’t use leading wildcards

Avoid SELECT *

Indexing

Use constraints

Analyze query plans

Compare optimized and original SQL

Look at the actual execution plan, not the estimated plan

Adjust queries by making one small change at a time
Rajanikant Hawaldar5y ago
1. Increase memory parameters of mysql server and underlying os resources
2. Use cache, give more memory to it.
3. Partition bigger tables(It's works really well if the workload is read intensive for bigger tables)
4. Use indexes, Build indices and verify query plans to use them.
5. If you have many indexes consider reducing them instead use invisible indexes to understand the query execution and use those indexs only
6. Consider temp dir and log buffer usage as well
7. And few specific to your database setup
8. Use SSD disks.
Adalat Khan5y ago
@Rajanikant Hawaldar
We are using SQL Server and MySql
Rajanikant Hawaldar5y ago
which database your using?
Satya Karki5y ago
HI
check this article, there are several ways to optimize.
https://www.toptal.com/sql-server/sql-database-tuning-for-developers