Zoho Analytics data upload through databridge

Hi, i'm new to Zoho Analytics and evaluating the free-trial.

I want to visualise data from my local Postgres database. I installed the databridge and uploaded 10 tables that i wanted to visualise.

The entire data sync took a lot of time and additionally, one of the larger tables (close to 1 million rows), is failing to sync with the below error:

Sorry, your data take more time to process than the allowed time. It may due to your Database Server response slow. Contact "[]" for further assistance

I had two questions, regarding this:

1) Will the data sync be faster if we install the databridge on the same server as the database server?

2) Can zoho work well with tables having millions of rows, specifically in terms of the data sync and queries. I understand that there is a total record limit, which is fine.

Thanks