Thursday, August 26, 2010

Slow Datagridview... Oh No!

So we all have been here, I had finished a project using VS2008, implementing  Datagridviews on litterally each and every form of the system. This had been a requirement from the onset as to ensure easy searching,navigation and capturing of data. So the data capture ladies start doing their thing and low and behold the dreaded call... they are unhappy with the speed of the DataGridView. I had to agree with them, the repaint of the and overall perfromance of the grid is awfull. So started a tedious process of trying to speed this up...

The first step was to look at my queries but they seemed fine. Not a lot I could do there.

I tried removing gridlines and embbed smaller images... really clutching at straws... could not get the speed up to acceptable levels.

All the while having users getting more and more irate with the performance.  

Here is what it looked like :

As you can see... a straight select of +-6000 rows got the grid choking to a repaint of more than 5 seconds!!

Anyway... after a lot of soul searching and delving deep a finally got to the solution. The same grid now loads/repaints in less than a second... here's what it looks like after my efforts


I wrote the solution into a DDL .. so just add the dll as a reference to your project like this.....


Then in your Form_Load event you just call  YourGridviewName.SpeedUpThisGridView(true);


and there you are.

This implemetation will sort out all your DataGridView speed issues. I wrote this in VS2008 and tested it in VS2010. Please note that this dll is only for Win APP's and not for Web or SilverLight

Works like a dream, with a lot of happy customers.

If you want a copy of this dll please email me at schalk@mineware.co.za and I will send it to you ASAP.

111 comments:

  1. This is amazing :) Took about 5 secs to install and improved performance many times over... Thanks!

    ReplyDelete
    Replies
    1. Hi Richard,

      I'm having the same problems with DataGridView performance, if you have Schalk's DLL, could you please send it to me at vietqto@gmail.com? Thanks very much.

      VietT

      Delete
  2. Dear schalk,

    Thanks to you for sending the Dll,
    DataGridView Performance is much better than the old one.

    You have done a great job.

    Best Regards,
    Surya.

    ReplyDelete
    Replies
    1. Hi,

      I'm having the same problems with DataGridView performance, if you have Schalk's DLL, could you please send it to me at vietqto@gmail.com? Thanks very much.

      VietT

      Delete
  3. Oh please, send me a copy. I sent you a mail a few days ago, are you still using that mail account? You should consider uploading it to Rapidshare and posting the link.

    Thanks.

    ReplyDelete
  4. Sorry J , must have missed it.. please resend to my above email, I'll send you a copy

    ReplyDelete
    Replies
    1. Hi Schalk,

      I'm having the same problems with DataGridView performance, could you please send the DLL to me at vietqto@gmail.com? Thanks very much.

      VietT

      Delete
  5. hello,

    will this work on VB2008? can you send it into my email also?

    thanks

    ReplyDelete
  6. Ok, this is fantastic. I've put a big

    // --THANKS SCHALK--

    in my code. As I'm the only one with access to that source, nobody will see it, but I guarantee you it's there. ;)

    Great job.

    ReplyDelete
    Replies
    1. Hi,

      I'm having the same problems with DataGridView performance, if you have Schalk's DLL, could you please send it to me at vietqto@gmail.com? Thanks very much.

      VietT

      Delete
  7. Hello,

    its not working in VB2008, i also emailed you and my email bounced back. when i Build the solution i got a Build Failed message but no error or warning were shown on the error list.

    ReplyDelete
  8. It really increases the speed of filling theDataGridView. Good work.
    Thanks

    ReplyDelete
  9. Are you still emailing this out? I sent you an email a week or so ago and haven't heard anything back

    ReplyDelete
  10. Hi, email delivery error. Anyone who has the dll, pls email me samuelg78@live.com.sg. Thks

    ReplyDelete
  11. Thanks Schalk,

    your the best !

    he solve my problem, he really sends you the solution to your email.

    :D

    ReplyDelete
  12. Thanks for sending the dll.
    You solved our performance problem and we now can really use our application in a proffesional way.

    Thanks a lot!!!

    ReplyDelete
    Replies
    1. Hi,

      I'm having the same problems with DataGridView performance, if you have Schalk's DLL, could you please send it to me at vietqto@gmail.com? Thanks very much.

      VietT

      Delete
  13. Thanks for your dll, it works like a charm. The rendering in painting disappears and it improve binding speed a lot. It's so awesome. I'm so too happy for that. Again, thank you very very much for your help.

    ReplyDelete
  14. Hi!
    I tried to send you an email but your address seems no longer valid because I got a delivery error message.
    Your dll would be very useful to me. Is it possible to receive it please?
    Thanks in advance.

    ReplyDelete
  15. Hi this is shankar dakolia

    i have just send you mail requesting the dll hope i get it thanks in advance

    ReplyDelete
  16. Anyone has the link to download the dll?

    ReplyDelete
  17. Hi to all,

    I tested the dll but still the DataGridView is loading so slow.

    The real solution to this is not to load all records into DGV.

    ReplyDelete
  18. Hi,

    I would like to request if you could send me the dll for speed up datagridview.

    Pls email to application.developer1@gmail.com

    Thanks a lot.

    ReplyDelete
  19. Hi. can u send me the dll. I would like to try it out

    malybirko@gmail.com
    thx

    ReplyDelete
  20. Sweet ***** this thing is amazing. vs.net 2010

    ReplyDelete
  21. Hi schalk,

    I am facing a similar issue and has been looking for a solution.
    I just have sent an e-mail to you.
    Could you please send me a copy of the DLL to
    shivudumaddi@gmail.com

    Thanks in advance,
    Shivudu M

    ReplyDelete
  22. Hi Schalk,
    I have the same problem. I just have sent an e-mail to you.Could you please send me a copy of the DLL to enzo.soprano@gmail.com.

    Thanx in advance,
    Crescenzo D.

    ReplyDelete
  23. Hi Schalk,

    I have the same problem. I just have sent an e-mail to you.Could you please send me a copy of the DLL to cvetan85@gmail.com.

    Thanx in advance,
    Cvele

    ReplyDelete
  24. Can some one please send me this dll.

    ReplyDelete
  25. I have sent you an email please send me a copy
    many thanks,
    Ben James

    ReplyDelete
  26. I send email... please send me a copy. Thanks.
    Alessandro

    ReplyDelete
  27. can you please send me the file ?
    thanks.

    ReplyDelete
  28. Hy,
    This is Michael. I sent you an email, I really need your fix.

    THanks again,
    Michael.

    ReplyDelete
  29. I have the same problem. I
    have sent an e-mail to you.
    Could you please send me a copy of the DLL to gvbhaskar.mca@gmail.com.

    ReplyDelete
  30. I have the same problem. I
    have sent an e-mail to you.
    Could you please send me a copy of the DLL to abhinavsaxena44@yahoo.com.

    ReplyDelete
  31. I have the same problem. I have sent an e-mail to you.
    Could you please send me a copy of the DLL to roland.ravasio@finitaliaspa.it

    Thanks again,
    Roland.

    ReplyDelete
  32. Please send to dyemz17@yahoo.com thank you so much i need this asap.

    ReplyDelete
  33. I've dropped you an email...but just to make sure; can you send the component to me too? My mail address is: s.b.bakker@gmail.com

    Thanks!!

    ReplyDelete
  34. Please send the file for me!!! thanks you!!
    h3w8529@gmail.com

    ReplyDelete
  35. Please send the file to
    leclercq.chris@gmail.com

    Thanks and nice work !!!!

    ReplyDelete
  36. Hi, I'm running into very slow DGV redraw performance. Please share the file with me : joan.lim@gmail.com.

    Thanks!

    ReplyDelete
  37. help me bro, i need the dll.
    ravenrocksat19@gmail.com

    ReplyDelete
  38. This comment has been removed by the author.

    ReplyDelete
  39. Can anyone send this dll to
    eda.okur@techneon.com.tr
    please? Thanks

    ReplyDelete
  40. This comment has been removed by the author.

    ReplyDelete
  41. Could you please share your DLL with me? I am at cmays637@gmail.com
    Thanks in advance.

    ReplyDelete
  42. Could you please share your DLL with me? I am at sudhir.bannu@gmail.com

    ReplyDelete
  43. Please email me the dll as well. Thanks!

    davidtstewart@gmail.com

    ReplyDelete
  44. Could you please share your DLL with me? Dirk_br@gmx.net

    ReplyDelete
  45. Could you please share your DLL with me? I am at lbmail21@yahoo.com.ar
    Many thanks!

    ReplyDelete
  46. Please send the file to
    lenhatnguyen3@gmail.com

    Thanks and nice work !!!!

    ReplyDelete
  47. can anyone send to me that kind of file...i'm also face same problem...my email is mohaiyedin@yahoo.com

    ReplyDelete
  48. I too would like a copy of the DLL to see if it alleviates the performance issues I am experiencing. I've tried emailing Schalk, but have received no response.

    Could someone please email me a copy at david.mcnamara AT sas DOT com

    Thanks, David.

    ReplyDelete
  49. Can anyone send this dll to
    karaca.c95@gmail.com
    please? Thanks

    ReplyDelete
  50. it seems that you can get your hands on this DLL if you install MadScan as stated here:
    http://www.shouldiremoveit.com/Madscan-89434-program.aspx
    After installing, copy the DLL then you're free to uninstall it. I don't know if MadScan has the rights to use the DLL...

    ReplyDelete
  51. I too would like to have a copy of the DLL to see if it solves the performance issues I am experiencing. I've tried emailing Schalk, but have received no response.

    Could someone please email me a copy at manithkempegowda@gmail.com

    Thanks, Manith Kempegowda

    ReplyDelete
  52. Same to me ... Can Someone send it ?

    ReplyDelete
  53. Plz send me this SpeedUpDGV.dll File its very urjent

    ReplyDelete
  54. Hi frnds..
    If any one has this dll plz send it to me

    ReplyDelete
  55. hi everyone
    if any one has this SpeedUpDGV.dll plz send me on khot44@rediffmail.com

    ReplyDelete
  56. Hello everybody,

    I couldn´t find the dll either...

    But what really made the difference for me was changing both properties "AutoSizeColumnsMode" and "AutoSizeRowsMode" to "None".

    We have more work to format the datagrid, but the speedy is really speedup if we leave these properties with the default values.

    ReplyDelete
  57. Can anyone send this dll to
    mtakayindisa@gmail.com
    please? Thanks

    ReplyDelete
  58. Doesn't work with .NET Framework 4.5.

    ReplyDelete
  59. Hi Schalk,
    I have the same problem. I just have sent an e-mail to you.Could you please send me a copy of the DLL to
    findasoul_jaydi@hotmail.com
    Thanx in advance

    ReplyDelete
  60. Can anyone send this dll to
    parabang@hotmail.com
    please? Thanks

    ReplyDelete
  61. Can someone please send this DLL to my email rmocca@gmail.com

    ReplyDelete
  62. Can anyone send this dll to
    sw8657@gmail.com
    please? Thanks

    ReplyDelete
  63. I have the same problem.
    Could you please send me a copy of the DLL to karthickbm90@gmail.com

    ReplyDelete
  64. Hi,
    could you please send me a copy of the DLL to francesco.bonifazi@hotmail.com

    ReplyDelete
  65. Hi,
    could you please send me a copy of the DLL to francesco.bonifazi@hotmail.com

    ReplyDelete
  66. Hi,
    could you please send me a copy of the DLL to simon.bravo@bcghouston.com

    ReplyDelete
  67. Hello all right?

    Could you send me the dll the datagridview

    Thanks

    ReplyDelete
  68. Hello,

    I read about your grid performance DLL and it will be great if I can a copy of the same.

    Can I also get a copy of the source code of the DLL? You can email me at sandeepnr@gmail.com

    Awaiting earliest reply,

    Thanks,
    Sandeep

    ReplyDelete
  69. Hi,
    could you please send me a copy of the DLL to
    claudio.marcandalli@gmail.com

    ReplyDelete
  70. I have the same problem.
    Could you please send me a copy of the DLL to
    claudio.marcandalli@gmail.com

    ReplyDelete
  71. Hello,
    Could you please send me a copy of the DLL to anilbabu04@gmail.com

    ReplyDelete
  72. Hi,
    could you please send me a copy of the DLL to manueligt@gmail.com

    ReplyDelete
  73. Hi,
    could you please send me a copy of the DLL to manueligt@gmail.com

    ReplyDelete
  74. Hi,
    can you please send me a copy of the DLL to jkpfeil@yahoo.de

    ReplyDelete
  75. Hi, can you send me also a copy of the DLL gembiart@gmail.com

    ReplyDelete
  76. Hi, can you send me also a copy of the DLL tiny2n@naver.com

    ReplyDelete
  77. Hi,
    can you please send me a copy of the DLL to ibo.khalo@hotmail.com?:)

    ReplyDelete
  78. Hi,
    can you please send me a copy of the DLL to crazy2685@hotmail.it:)

    ReplyDelete
  79. Hey,

    Could you send me a copy please at cpmcc94@gmail.com? Thanks!

    ReplyDelete
  80. Hey,

    Could you send me a copy please at yusuf.maniacpc@gmail.com? Thanks!

    ReplyDelete
  81. Hi guys,
    Can anyone send me a copy of the dll to resotomayor85@gmail.com, Thanks.

    ReplyDelete
  82. explorercris@yahoo.com a copy please

    ReplyDelete
  83. please send me dll to kamrul1cse@gmail.com please

    ReplyDelete
  84. Kindly mail me the dll at hardeep.btech@gmail.com. TIA

    ReplyDelete
  85. pls send me the dll to sherfang03@yahoo.com.sg. thanks you

    ReplyDelete
  86. Please send me one copy of the dll to thanhnam.dhhd@gmail.com, thanks

    ReplyDelete
  87. Hi,
    could you please send me a copy of the DLL to suj2911@gmail.com

    ReplyDelete
  88. It is grate.
    My email
    Meehal@hotmail.com

    ReplyDelete
  89. Very Niice, My Mail pawarsagar4u@gmail.com

    ReplyDelete
  90. Hi,

    Ive been looking for something like this for along time and failed to make any significant progress in my own efforts.

    could you please send me a copy to bonio55@hotmail.com

    kind regards

    Shaun

    ReplyDelete
  91. This comment has been removed by the author.

    ReplyDelete
  92. Hi, I will be very thankful if you please send me a copy of this dll.
    mahdihosseinzadeh67@gmail.com

    ReplyDelete
  93. Anyone have the DLL? Kindly share and send a copy to koontpt@yahoo.com Appreciate that. Thanks

    ReplyDelete
  94. Hi. May i request for copy of your DLL? Here's my email. ronnelbobbybantugpaulino@gmail.com. Thank you.

    ReplyDelete
  95. Please send a copy of your dll to me. thanks!
    darrell.mulder@vbssys.com

    ReplyDelete
  96. Please help me send that dll I need to improve slow speed of Datagridview. Thanks you
    my email: huynhnhatvu1992@gmail.com

    ReplyDelete
  97. Does the datagridview speed up when I update the rows to make it visible(not)

    ReplyDelete
  98. Hi Sir. May i request for copy of DLL? Here's my email ronnelbobbybantugpaulino@gmail.com
    Thanks.

    ReplyDelete
  99. This comment has been removed by the author.

    ReplyDelete
  100. Please help me send that dll I need to improve slow speed of Datagridview. diegoangelzsanpedro@gmail.com

    ReplyDelete
  101. Could you send me the dll, please? dqq@o2.pl

    ReplyDelete
  102. i was able to locate this dll and tried it. It did NOTHING to speed up my datagridview when trying to hide a large number of rows. What DID work was setting the autosize mode of each column to none before hiding the rows, then restoring the settings after.
    So ... don't worry if you can't get a hold of this dll ... it doesn't work.

    ReplyDelete
  103. Can anyone send this dll to
    tuyencse@gmail.com
    please? Thanks

    ReplyDelete