Click here to Skip to main content
12,550,379 members (44,381 online)
Rate this:
Please Sign up or sign in to vote.
See more: SQL-Server
Hi expert!!!

i developed windows base application in, 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,
Posted 1-Feb-13 0:00am
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
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.
Member 9444634 1-Feb-13 7:53am
ok, i think its help.

after u say i implement'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 | Mobile
Web02 | 2.8.161021.1 | Last Updated 1 Feb 2013
Copyright © CodeProject, 1999-2016
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