We Do Performance, Optimization, and Troubleshooting of SQL Queries
What makes queries slow?
DEAD LOCKS. This happens when there are too many transactions on your SQL and some other queries have to wait
for the transactions to finish.
BAD SERVER SPEC. A server with more RAM and CPU will outperfome a server with a smaller spec.
Server's that are running old operation system and old hardware will always be slower that new servers.
POOR DATA INDEXES. When columns are not indexed the SQL will scan all the tables to find the required data, outdated indexes will
also cause slow SQL queries.
DONT SELECT DATA THAT YOU DONT NEED. Selecting 5000 records to the users is an over kill, no user cant go through
5000 records, provide filter and paging for the users to access only the data they need.
ORM. Some ORM's produce queries that are not optimized, choosing the right ORM for your system can save you a lot of headache. .