问题
Michael Lei · 四月 21

来自英文社区的问题:SQL ODBC连接查询运行的时间比预期的长

我有一个SQL查询,我想使用SQL外向适配器从Caché Ensemble针对MS SQL运行。如果我直接从MS SQL Studio运行此查询,则最多需要7秒钟的时间,并返回大约50万行。该行仅包含一列,它是一个大小均相同的数字,如果我在Ensemble生产环境中运行此查询,它将一直运行但不会返回响应。同样的查询在Enssemble环境外的caché中运行,将结果写入文件,返回的结果大约需要3分钟完成。但是如果我把结果加载到一个列表或记录图(Record Map)中,它就会一直运行下去。 能加载到记录图或列表中的数据行数是否有限制,是什么原因导致了这种情况的发生?这个查询所返回的文件大约是5.7MB。

 

SQL ODBC Connection query running longer than expected

I have  a SQL query that I want to run against MS SQL from cache ensemble using the SQL outbound adapter. If I run this query direct from MS SQL Studio it take about 7 seconds MAX and returns about half a million rows. The row only contains one column it is a number all same size and if I run this query in the production in ensemble it takes for ever the production finishes without getting the response back. The same query run in cache outside the ensemble environment writing results to a file it returns results taking about 3minutes to complete. But if I load the results into  a list or Record map it runs for ever is there a limit to the numbers of rows of data you can load to a record map or a list and what is it that I missing that might be causing this to happen? The file returned by this query is about 5.7mb

产品版本: Caché 2018.1
$ZV: Cache for Windows (x86-64) 2018.1.4 (Build 505_1U) Thu May 28 2020 10:01:40 EDT [HealthShare Modules:Core:15.032.9035 + Linkage Engine:15.032.9035]
00
1 0 0 23
Log in or sign up to continue