Loading data to Spread too slow ??

Posted by: raccsdl on 8 September 2017, 12:41 pm EST

  • Posted 8 September 2017, 12:41 pm EST

    Hi Everyone.

    I am using Microsoft Enterprise Library for DAL (Data Access Layer) and Spread 2.5 Trail version.

    I connect database and get information of one table which have around 2000 records. it display too slow when I put datasource to spreadSheet on destop application ?  I write code on VB NET 2005 (.NET Framework v2.0)  ? Can someone explan for me more about this ? Or Can give me a sample ?

    Thanks so much for your Help


  • Replied 8 September 2017, 12:41 pm EST

    Thanks for your help Scotts. I will reply to you soon  when I am checking it follow your solution guiding me.


    Thanks.
  • Replied 8 September 2017, 12:41 pm EST

    Hi Scotts.

    I am trying add TextRender.dll to my project  or installing to GAC but the result seems like not change anything more. I send back to you images which  have just captured from my desktop.

    In this case, How do I config anything in myproject when I added that file to project references or installing to GAC for Project using it ?

    Have you got any other solution for this case ? Could you send to me a example involved in this problem ?

    Thanks for your help so much. I am waiting for  your reply.
     



  • Replied 8 September 2017, 12:41 pm EST

    Hello,


    I would suggest breaking this into two button click events to see what is taking the long time to implement. Have one button make the connection and fill the DataTable with the records and another button to set the DataSource property of the Spread. Then you can find out what is taking the long time to complete.

  • Replied 8 September 2017, 12:41 pm EST

    Thank for your help, Scotts. Loading data to SpreadSheet didn't slow, I checked it follow your way. When I maximize the form which it have two spreadSheet inside, The SpreadSheets repaint slowly. I don't know why grid repaint slowly when the form change to maximize. I sent to you the picture of repainting of grids when I chose maximize button on the form.

    Have you got any idea or solution for this problem ? I am waiting for your help. Thanks so much.




  • Replied 8 September 2017, 12:41 pm EST

    Hello,


    The Spread control uses the .NET GDI+ for drawing text. These painting routines are slow. We have created a TextRenderer.dll that when present in the project references or installed in the GAC will be used for rendering text. This will use the GDI drawing routines which are faster than the .NET GDI routines.

  • Replied 8 September 2017, 12:41 pm EST

    Hello,


    There is nothing to configure. If the project can find the dll, then it will be loaded and used. Otherwise, default painting will happen. If this is not causing the painting to be faster, then there is nothing else we can do. Could you post a small zipped project reproducing the behavior for us to debug?

  • Replied 8 September 2017, 12:41 pm EST

    Hi Scotts.


    As you said, I did not do worng anything right ? Now I sent to you small test gird example and the figure of my computer. PCU celeron 1.8Hz, RAM  1G and using Windows 2000.


    It's load data okay but the grid repaint slowly when I change the form to maximize. 


    Thanks for your help I am waiting to your reply.


     


    Thanks you so much.


     


     


    2007/07/TestGrid.zip
  • Replied 8 September 2017, 12:41 pm EST

    Hello,


    The way you have the project now is the optimal for the Spread painting. There is a lot of processing of the Spread to determine how to paint, which is causing the delay you are seeing. We have been updating the painting routines in every release. I then tested your project with the latest maintenance release (2.5.2011) and it did paint faster. Also, we will be having a new maintenance release within the next couple of months that will increase peformance a good amount more.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels