Data refresh from sql server to calc sheet slow

Hello,

I realize these types of questions are difficult if not impossible to diagnose but are there any settings in calc that might be causing things to import slowly during a refresh from a sql server instance? We have a import from a table with 5,000 rows and maybe 30 columns of varchar (25) which is taking 5+ minutes to do a data refresh. Are there some common problems that we could look into to possibly fix to speed things up?

Thank you!

Was the query executed from another program and it’s quick?. The length of the records, I think, not usually it’s the more important, many times, specially with complex queries, it’s relevant how it is designed.

Hello,

This appears similar to an Oracle connection. See this post → base to oracle database connection slow.

The related bug report link is in the comments of the answer.

Have not recalled seeing any posts specifying this problem regarding ‘sql server’. You may also want to file a bug report. That link is also in the comments of the answer.