Click here to Skip to main content
15,868,074 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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
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.

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.
 
Share this answer
 
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)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900