The execution time for the compiled LINQ query is 305 ms on the first execution and 15 ms on subsequent ones.
对于编译了的LINQ查询而言,第一次执行耗时305毫秒,而随后的执行时间则为15毫秒。
Make sure that the query is a dynamically compiled statement.
确保查询是一个动态编译的语句。
Similar to MySQL Administrator, MySQL Query Browser’s source code is available and can be compiled on Linux on POWER.
类似于MySQLAdministrator,也可以获得 MySQL查询浏览器的源代码并在 POWER上 Linux中编译它。
For a NoTracking query, the compiled LINQ query outperforms the standard LINQ query both in first execution and in subsequent executions.
如果使用NoTracking查询,无论是第一次执行还是随后的执行,编译的LINQ查询都要优于标准的LINQ查询。
Note that the second execution of the compiled LINQ query is equivalent to the second execution of the Entity SQL query.
注意,编译的LINQ查询的第二次执行与EntitySQL查询的第二次执行相等。
The query is compiled and execution of the query at the data source starts.
该查询首先经过编译,然后在那个数据源上开始执行。
With REOPT ALWAYS, the query will be re-compiled and the access plan will be re-generated based on run-time value.
通过使用REOPT ALWAYS,这个查询将会重新编译,而这个存取计划将基于运行时值重新生成。
Their individual results are then compiled and returned to the query submitter.
之后,再收集各个数据库分区上得到的结果,并返回给查询提交者。
So, by implementing stored procedure you will gain in time as it's compiled and not interpreted each time like a normal entity framework query.
因此,通过执行存储过程中你将时间作为它的编译和解释每一次像一个正常的实体框架查询增益。
To execute an SQL query, it must first be compiled into a byte-code program using one of these routines.
要执行SQL查询,必须先使用这些例程之一将它编译成字节码。
Query expressions can be compiled to expression trees or to delegates, depending on the type that the query is applied to.
查询表达式可以编译为表达式树或委托,具体取决于查询所应用到的类型。
Because view generation is a significant part of the overall cost of executing a single query, the Entity Framework enables you to pre-generate these views and include them in the compiled project.
视图生成是执行单个查询的总开销的重要部分,因此实体框架让您可以预生成这些视图并在已编译项目中包含这些视图。
Because view generation is a significant part of the overall cost of executing a single query, the Entity Framework enables you to pre-generate these views and include them in the compiled project.
视图生成是执行单个查询的总开销的重要部分,因此实体框架让您可以预生成这些视图并在已编译项目中包含这些视图。
应用推荐