Click here to Skip to main content
12,828,403 members (46,848 online)
Rate this:
Please Sign up or sign in to vote.
See more: VB VB.NET
I have huge database in sql server 2005 and when i use select query with where conditions then it will get more response time to display that data on datagridview. can anybody help me to overcome this issue or how to use JIT.
Posted 19-Dec-12 0:55am
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

You don't use JIT - read this for more of an explanation of what exactly JIT is[^].

As for you query, take a look at this article[^]
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

1. Create index on columns which you use in where conditions.
2. Use same datatypes on where conditions e.g. emp_id (number) = 123
3. Create a Stored Procedure to fetch the data rather than using dynamic queries
4. Fetch data from tables rather than views
5. If you fetch data from multiple tables, use joins rather than subqueries
6. Avoid using functions on select columns

.Net code:
1. Use classes from SQL provider (System.Data.SqlClient) only to fetch the data.

These are the steps you can start with for the performance improvement. Once you start these kind of optimization, you will realize that there is no magic to get data within seconds.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170326.1 | Last Updated 19 Dec 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100