You are here:

MS SQL Server/To improve sql query performance

Advertisement


Question
Hi Anup,
I am using sql server 2012. I have table which have 2,00,000 rows. When I am working on my local pc it takes 1-2 second to execute on sql server and working fine on my localhost. But when I upload project on online server it takes 1:34 mins to execute o sql server and also when I search from form and load only 100 rows to form, it takes too much time to fetch records.

I searched for indexing and full index searching but not getting how to use it. Have you any solution that take less time and execute fast on forms.

Thanx.

Answer

Karan

The "online" server is it in shared hosting? or a virtual machine that you can remote into. My guess is it is the Disk IO speed that is causing the slow-down. Way to confirm is run an execution plan on both the online and local. Compare the two. This will give you some direction. Once you identify which part is slowing it down you can try partitioning the table or optimizing your query by adding an index based on your Query and its criteria.

Basic info on how to get a Query Plan can be found here >> https://msdn.microsoft.com/en-us/library/ms189562(v=sql.110).aspx

If you need more help, then will need more info from you. Like your SQL-Table Schema Structure (Columns, etc). List your SQL-Queries you are running against it.

Hope this helps!

Good luck.

-Anup

MS SQL Server

All Answers


Answers by Expert:


Ask Experts

Volunteer


Anup Mistry

Expertise

T-SQL, Database design, Stored Procedures, Schema, .NET Classes, SQL Server, SQL Compact, SQL Express, ADO.NET, Administration, Pretty much anything inside SQL-Server. Will help research if I do cannot answer or provide exact answer. My way of giving back to the programming community

Experience

Been software developer for 10+ years. Worked on various large business applications (Warehousing + Distribution, Financial, Healthcare). Worked on Mobile development (Proof of Delivery, Consumer based Infotainment application, Web based apps). Never stopped programming all these years. Worked on embedded, small, medium and large scale databases. Even in leisure time am reading computer related magazines. Have been a visiting professor at educational institutes teaching corporate and college students alike. Held Systems Analyst, Technical R&D member positions as well.

Organizations
Brainbench certifications: (Microsoft.NET, Java 1, Oracle, Network Technical National Center for Software Technology: D-Level (software engineering exam)

Publications
Speaker at Planet PDA on topic “Developing Apps for the Pocket PC” Seminar at Fairleigh Dickinson University, NJ on topic “Wireless LAN and Wireless Software applications”

Education/Credentials
Bachelors Degree in Engineering Electronics and Telecommunications Mobile Cellular Systems Satellite Communications

©2016 About.com. All rights reserved.