Is there any guidance on when ODBC or JDBC has better performance for loading and inserting data? In particular, I am using BigQery and MacOS with the Simba ODBC and JDBC drivers.
-
Login or Register
- Log in with
- You are not logged in. You can browse but not post. Login or Register by clicking 'Login or Register' at the top-right of this page. For more information on Statalist, see the FAQ.
-
-
The database-specific JDBC/ODBC driver and network latency are the main factors for performance with loading and inserting data. The guidance I would give is to use jdbc on Mac and Unix systems because there is better database vendor JDBC driver support. I would also recommend jdbc if you are working across multiple operating systems because the setup/Stata code will be the same on all systems. -
This is great! I will give jdbc a try.
Comment
Comment