rethinkdb optimization

[mohit5540]

• find out slow queries for apis
• query optimization
• rethinkdb query options

[mohit5540]

• add index to related fields in rethinkdb (search fields)
• for Feathers applications, add following configurations for rethinkdb connection : buffer : 20 timeoutGb: 60000
• check all custom queries where filter is used. create simple or compound index for search fields as required. use getall query instead filter. ref : https://medium.com/connect-the-dots/optimizing-queries-in-rethinkdb-584d7f660cb
• check for bulk inserts in application
• for rethinkdb services, add close connection at bottom of code

[mohit5540]

• load testing and performance for different scenarios attached : feathersjs_rethinkdb_load_testing.xlsx

[KrishnaPG]

What is the performance difference before and after the change of filter to getAll?

[Zalasanjay]

Bellow attached screen shot is showing "ReQL query timed out" on admin panel when rethinkdb is configured in cluster mode

at the same time error showing on service console is attached bellow

[Zalasanjay]

screenshot for RethinkDB "Entering in slow growth mode" on RethinkDB Dashboard

when DB goes into "Entering in slow growth mode" that time error shown in backend