Click here to Skip to main content
11,484,640 members (59,105 online)
Rate this: bad
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 1:00am
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
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 at 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
0 Maciej Los 190
1 Sergey Alexandrovich Kryukov 180
2 Raje_ 155
3 OriginalGriff 147
4 Mehdi Gholam 120
0 Sergey Alexandrovich Kryukov 8,484
1 OriginalGriff 7,948
2 Sascha Lefèvre 3,199
3 Maciej Los 2,681
4 Richard Deeming 2,370

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