Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-Server
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 at 1-Feb-13 6:01am
   
any tricks for retrieve one data from large database????
CPallini at 1-Feb-13 6:12am
   
You didn't show any detail. How can we possibly help?
Abhishek Pant at 1-Feb-13 6:19am
   
Optimize your queries; use Stored procedures.
this may help you
ASP.NET Pagination[^]
Vyacheslav Voronenko at 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 at 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
0 Sergey Alexandrovich Kryukov 893
1 OriginalGriff 400
2 CPallini 275
3 George Jonsson 191
4 Richard Deeming 145
0 OriginalGriff 5,450
1 Sergey Alexandrovich Kryukov 4,532
2 CPallini 4,500
3 George Jonsson 3,102
4 Gihan Liyanage 2,445


Advertise | Privacy | Mobile
Web03 | 2.8.140916.1 | Last Updated 1 Feb 2013
Copyright © CodeProject, 1999-2014
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