1000 rows [Feb 12]

Discord-Discussions
1

:raising_hand_man: Vlas asked

Hello, guys! I’ve just configured environment variables to shows 1000 records per page and ran into a problem: it needs 7 seconds for get request for database. I want to make it faster. Who knows, how I can improve database performance, if I use RDS (AWS)? Which parameters for my database instance you recommend?

2

:person_tipping_hand: o1lab replied

1000 rows is a lot in one request. :grinning:

3

:person_tipping_hand: o1lab replied

Tell is more about the view

4

:person_tipping_hand: o1lab replied

Number of columns

5

:person_tipping_hand: o1lab replied

Linktoanotherrecord

6

:person_tipping_hand: o1lab replied

Lookups

7

:person_tipping_hand: o1lab replied

Also we default to max of 100… did u happened to change code too ?

8

:raising_hand_man: Vlas replied

It has 60 columns with no linktoanotherrecords and lookups. So, you recommend to use 100 records per page?

9

:person_tipping_hand: o1lab replied

100 is good. We will move to without pagination later sometime. Even then the request will be lesser and based on scroll speed we can get more records. But this will come later

10

:raising_hand_man: Vlas replied

Oh, thank you. I just thought, that I need to improve database server. But, as I see, it actually has only 10% CPU utilization

11

Autogenerated from discord

Join NocoDB’s community

Discord • Twitter • Reddit • Docs