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.

93 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 u send me the mail please

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

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

    THanks again,
    Michael.

    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 gvbhaskar.mca@gmail.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 abhinavsaxena44@yahoo.com.

    ReplyDelete
  32. 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
  33. Please send to dyemz17@yahoo.com thank you so much i need this asap.

    ReplyDelete
  34. 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
  35. Please send the file for me!!! thanks you!!
    h3w8529@gmail.com

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

    Thanks and nice work !!!!

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

    Thanks!

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

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

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

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

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

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

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

    davidtstewart@gmail.com

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

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

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

    Thanks and nice work !!!!

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

    ReplyDelete
  49. 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
  50. Can anyone send this dll to
    karaca.c95@gmail.com
    please? Thanks

    ReplyDelete
  51. 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
  52. 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
  53. Same to me ... Can Someone send it ?

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

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

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

    ReplyDelete
  57. 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
  58. Can anyone send this dll to
    mtakayindisa@gmail.com
    please? Thanks

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

    ReplyDelete
  60. 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
  61. Can anyone send this dll to
    parabang@hotmail.com
    please? Thanks

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

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

    ReplyDelete
  64. I have the same problem.
    Could you please send me a copy of the DLL to karthickbm90@gmail.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 francesco.bonifazi@hotmail.com

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

    ReplyDelete
  68. Hello all right?

    Could you send me the dll the datagridview

    Thanks

    ReplyDelete
  69. 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
  70. Hi,
    could you please send me a copy of the DLL to
    claudio.marcandalli@gmail.com

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

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

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

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

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

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

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

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

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

    ReplyDelete
  80. Hey,

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

    ReplyDelete
  81. Hey,

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

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

    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