search

EnterpriseDB / mysql_fdw

PostgreSQL foreign data wrapper for MySQL
Other
523 stars 161 forks source link

fetch size option? #192

Closed jackrabbithanna closed 2 years ago

jackrabbithanna commented 4 years ago

I'm trying to use mysql_fdw to connect to a MySQL View, which has a complex query and could have over 1 million results.

If I query against the View in MySQL .. I get query speeds in like a few seconds, but the same query in the FDW is many minutes :(

I was wondering if the server option 'fetch size' as or will be implemented sometime soon.

Thanks!

Kazmirchuk commented 3 years ago

+1 this would be very relevant for my project as well. What is the current default fetch size?

jeevanladhe commented 3 years ago

Hi,

Current fetch size is 100, and currently it is not configurable. Thanks for showing interest in this, we can add this in our TODO list and will try to implement this in future releases depending on other priorities.

Regards, Jeevan Ladhe

On Wed, Mar 31, 2021 at 7:05 PM Petro @.***> wrote:

+1 this would be very relevant for my project as well. What is the current default fetch size?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/EnterpriseDB/mysql_fdw/issues/192#issuecomment-811073240, or unsubscribe https://github.com/notifications/unsubscribe-auth/AQKBZ4SPWPOA6FKSGKBGBFDTGMQKPANCNFSM4MFBB7RA .

surajkharage19 commented 3 years ago

Hi,

With the recent commit ee131775b71bae9060daf9b690fe44c7aa61b263, we can set fetch_size at per-table or per-server level in mysql_fdw. Can you please check if that serves the purpose at your end?

surajkharage19 commented 2 years ago

Hi @jackrabbithanna and @Kazmirchuk,

We have not received further updates from you on this. Hoping that issue is resolved. We are closing the case for now. If the issue persists, you can reopen the case anytime.