uniDBGrid - SUPER LOW with lots of records

[vbdavie]

The uniDBGrid is fairly good. But i notice that if the ADO dataset contains lots of records (like 30,000) then it becomes horribly slow.

I do NOT have calculated fields. I do NOT use client cursor location (i use serverside cursor to my SQL database)

I use the PAGED web option so that only a few records are displayed at a time. My page size is 4 records.

My VCL program that uses TDBGrid loads the grid in about 4 seconds. The similar web version that uses TuniDBGrid loads in about 50 seconds. That's a huge difference.

Is there an explanation?

Thanks

Davie

[irigsoft]

9 hours ago, vbdavie said:

The uniDBGrid is fairly good. But i notice that if the ADO dataset contains lots of records (like 30,000) then it becomes horribly slow.

I do NOT have calculated fields. I do NOT use client cursor location (i use serverside cursor to my SQL database)

I use the PAGED web option so that only a few records are displayed at a time. My page size is 4 records.

My VCL program that uses TDBGrid loads the grid in about 4 seconds. The similar web version that uses TuniDBGrid loads in about 50 seconds. That's a huge difference.

Is there an explanation?

Thanks

Davie

Hi, I have the same problem with Grid with many columns (hidden and visible). I thing the problems is on Ext.Grid used by default with unigui.

You can try some optimization with javascript, or use some other grids.

https://www.sencha.com/blog/7-tips-for-optimizing-performance-in-javascript-grids/

https://www.infragistics.com/community/forums/f/retired-products-and-controls/14363/how-to-optimize-webgrid-with-large-number-of-columns

 

[Abaksoft]

14 hours ago, vbdavie said:

s there an explanation?

Thanks

Davie

ADO connectivity is an old technology.

You can try a professional one, very fast from DEVART.

Download their free demo for Delphi  unidac or a specific one for your RDBM.

https://www.devart.com/dac.html

[AlbertoVesx]

dont use ADO