Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Web Development
  3. ASP.NET
  4. Performance Issues while populating datagrid

Performance Issues while populating datagrid

Scheduled Pinned Locked Moved ASP.NET
databaseperformancequestioncode-review
3 Posts 3 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • Z Offline
    Z Offline
    zareee
    wrote on last edited by
    #1

    Hi, I have a datagrid to which a database table called "employee" need to be binded. there are 9999 records in my table.while i bind the datagrid it takes several minutes for it to load... is there any other ways to improve its performance so that i can reduce the time of loading the page?? plz reply ASAP... Thanx in advance,

    zari

    C E 2 Replies Last reply
    0
    • Z zareee

      Hi, I have a datagrid to which a database table called "employee" need to be binded. there are 9999 records in my table.while i bind the datagrid it takes several minutes for it to load... is there any other ways to improve its performance so that i can reduce the time of loading the page?? plz reply ASAP... Thanx in advance,

      zari

      C Offline
      C Offline
      Christian Graus
      wrote on last edited by
      #2

      Well, one common sense UI decision would be to not have 10,000 records in your grid. The datagrid is designed for common UI tasks. If you need to load 10,000 records, you need to find a commercial grid that deals with this ( essentially by only loading small subsets of that data at a time )

      Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

      1 Reply Last reply
      0
      • Z zareee

        Hi, I have a datagrid to which a database table called "employee" need to be binded. there are 9999 records in my table.while i bind the datagrid it takes several minutes for it to load... is there any other ways to improve its performance so that i can reduce the time of loading the page?? plz reply ASAP... Thanx in advance,

        zari

        E Offline
        E Offline
        eyeseetee
        wrote on last edited by
        #3

        This seems to be a common question in this forum. Why not cut down the number of records by filtering them, maybe on search criteria by a user.This way not so many are being binded to a datagrid Other then that follow the advice of CG

        We are not a Code Charity

        1 Reply Last reply
        0
        Reply
        • Reply as topic
        Log in to reply
        • Oldest to Newest
        • Newest to Oldest
        • Most Votes


        • Login

        • Don't have an account? Register

        • Login or register to search.
        • First post
          Last post
        0
        • Categories
        • Recent
        • Tags
        • Popular
        • World
        • Users
        • Groups