Performance problem with DBGrid - Paged=true

[erich.wanker]

Hello.
How can i use the "WebOptions / Paged" without loosing performance ?

Very Fast:
uniDbGrid1.Paged = false;
ZQuery.Sql.append('SELECT * FROM table ORDER BY field LIMIT 50 OFFSET 1' );

Very Slow:
uniDbGrid1.Paged = true
uniDbGrid1.PageSize = 50
uniDbGrid1.FetchAll = False
uniDbGrid1.Buffered= False
ZQuery.Sql.append('SELECT * FROM table ORDER BY field' );

 

UniGui: 1.90.0.1523

MySQL Tabel with 100.000 Records

Connection via ZeosLib 7.7-Components

Apache 2.4

 

ThanX for help

Erich

 

Stay save - stay at home -  Stay healthy  !!!

 

 

[Wilton Ergon]

the first select will certainly be much faster than the second, and a table with 100k records.
the problem is not pagination, if yes your select

[erich.wanker]

hi wilton_rad

i thought, a paged uniDBGrid with PageSize 50 will make the same  as "Skip" or "LIMIT"  ? .. 

 

OffTopic: i now made my own "Paged" with 3 Icons .. first, prior, next  - no "last" because i dont want to read the recordcount of ALL effected records (needs time - what i want to reduce)

Nice greetings

Erich