Click here to Skip to main content
13,147,182 members (29,634 online)
Rate this:
 
Please Sign up or sign in to vote.
See more:
Hi expert!!!

i developed windows base application in C#.net, and use SQl server as Database.


it's work perfect while record up-to 20000 but when record is 150000 then performance is too slow.

plz give any suggestion!!!


Thank you,
Tarun
Posted 1-Feb-13 0:00am
Comments
Member 9444634 1-Feb-13 6:01am
   
any tricks for retrieve one data from large database????
CPallini 1-Feb-13 6:12am
   
You didn't show any detail. How can we possibly help?
Abhishek Pant 1-Feb-13 6:19am
   
Optimize your queries; use Stored procedures.
this may help you
ASP.NET Pagination[^]
Vyacheslav Voronenko 1-Feb-13 7:00am
   
Have you looked at execution plan? Provide screenshot or it's output.
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Your query is not clear but you can apply Indexes on columns and If you are displaying data into any control then use paging. Fetch only data which are required. Fetching this much of data are useless.
  Permalink  
Comments
Member 9444634 1-Feb-13 7:53am
   
ok, i think its help.

after u say i implement paging.....it's work fast.

but not proper works in unbounded data grid view column.

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 |
Web02 | 2.8.170915.1 | Last Updated 1 Feb 2013
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