Jump to content


Photo

DBGrid sync delayed with others DBControls


  • Please log in to reply
9 replies to this topic

#1 MichaelT

MichaelT

    Member

  • uniGUI Subscriber
  • PipPip
  • 29 posts

Posted 12 June 2018 - 08:00 AM

Hello,
 
I'm trying to create a sample App with a DBGrid linked to DataSource1 linked to Query and UniDBEdit linked to the same DataSource1.
After running the application, when I scroll in DBGrid, UniDBEdit is refreshed with a significant lag compared to DBGrid (see video).
 
How can I optimize this behavior and make it more fluid?
 
Best regards,

Attached Files


  • 0

#2 Delphi Developer

Delphi Developer

    Advanced Member

  • Moderators
  • 5307 posts

Posted 12 June 2018 - 08:11 AM

Hello,

 

I'm looking at some demo examples, and I do not see a significant lag

 

Can you make a simple testcase for this if possible ?!


  • 0

#3 MichaelT

MichaelT

    Member

  • uniGUI Subscriber
  • PipPip
  • 29 posts

Posted 12 June 2018 - 08:51 AM

Please find a simple example in attachment. I use a ClientDataset. The ClientDataSet contains really more 190 columns but I show only 5 persistents fields.

More there visibles fields, more there lags...  

 
ExtJS native is more fluid with big DBGridList, why uniGUI is more slowly ?  http://examples.senc.../#big-data-grid
 
 
Best regards,
 

Attached Files


  • 0

#4 Delphi Developer

Delphi Developer

    Advanced Member

  • Moderators
  • 5307 posts

Posted 12 June 2018 - 08:58 AM

TwwDataSource ?


  • 0

#5 Delphi Developer

Delphi Developer

    Advanced Member

  • Moderators
  • 5307 posts

Posted 12 June 2018 - 09:00 AM

What is your version of Delphi?


  • 0

#6 MichaelT

MichaelT

    Member

  • uniGUI Subscriber
  • PipPip
  • 29 posts

Posted 12 June 2018 - 09:11 AM

Sorry, we use the components Woll2Woll.

I attached the new demo with simple DataSource

 

Regards,

Attached Files

  • Attached File  Demo.zip   300.45KB   2 downloads

  • 0

#7 MichaelT

MichaelT

    Member

  • uniGUI Subscriber
  • PipPip
  • 29 posts

Posted 12 June 2018 - 11:58 AM

What is your version of Delphi?

Delphi Tokyo 10.2.3


  • 0

#8 Delphi Developer

Delphi Developer

    Advanced Member

  • Moderators
  • 5307 posts

Posted 12 June 2018 - 12:36 PM

I do not see a significant lag

 

Attached File  _grid.gif   1.62MB   2 downloads


  • 0

#9 MichaelT

MichaelT

    Member

  • uniGUI Subscriber
  • PipPip
  • 29 posts

Posted 12 June 2018 - 01:34 PM

Could you please check with this testcase :

 

- Click the first record

- Push Bottom arrow key while 15 sec.

- Release the key => You should see the component UniDBEdit refresh himself while somes seconds

 

Do you have this effect ?


  • 0

#10 mohammad

mohammad

    Advanced Member

  • uniGUI Subscriber
  • PipPipPipPip
  • 844 posts
  • LocationKufur Kassem, Palestine

Posted 16 June 2018 - 09:54 AM

Hi, have you debug the app using developers tools in chrom and see the network tab. When u scroll there is ajax request goes to the server to tell him about current record and the server also updates your edit with the desired value. If your network has issues then this will affect the performance. The best solution is tp use client side code to update the edit text, I always use that especially when I do search on the grid.
  • 0




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users