ruowan commented on issue #1454: URL: https://github.com/apache/arrow-adbc/issues/1454#issuecomment-1982533320
I test the paging locally; our existing solution duration is 1.3s but with the paging. the Duration has performance downgrade. And I guess the `SHOW TABLES LIMIT FROM` execute and retrieve all result only return the limit count of result which cause this performance downgrade. |SHOW TABLE | SHOW TABLE WITH PAGING| Limit | | ----------------- | ----------------------------- | ----- | | 1.3s | 13.6s | 100 | | 1.5s | 8.3s | 200 | | 1.5s | 7.6s | 400 | -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
