查询超时-无论如何增加价值? [英] Query TimeOut - anyway to increase value?

问题描述

我有一个基于sql server中的视图的表，大约. 25万条记录，

I have a table based on a view in sql server, approx. 250K records,

连接到该表的搜索屏幕查询所用的时间超过30秒，因此我无法加载数据-检查您的网络连接.

The query for the search screen connected to that table is taking longer than 30 seconds, hence I am getting unable to load data - check your network connection.

增加web.config中的连接超时无效-是否可以将默认查询超时增加30秒?

increasing the connection timeout in the web.config has no effect - is there a way to increase the default query timeout of 30 secs?

thx

MrP

推荐答案

我不知道是否可以更改特定的超时时间，但是我还有其他一些方法建议:

I don't know if there is a way to change that particular timeout, but I have a couple of other suggestions:

您是否向LightSwitch实体添加查询以限制返回的记录数? (您要向客户返回250,000条记录.)

Did you add a query to the LightSwitch entity to limit the number of records returned? (Are you returning 250,000 records to the client.)

您在数据库表上有索引吗?

Do you have indexes on the database table(s)?

该视图在SQL Server Management Studio中运行需要多长时间?

How long does the view take to run in SQL Server Management Studio?

您知道吗，如果您将更改发布到数据库中，发布过程将删除您已建立的所有索引? (而且您必须手动再次添加它们.)

Did you know that if you publish changes to your database that the publishing process will delete any indexes that you have built? (And you have to add them again manually.)

标记

这篇关于查询超时-无论如何增加价值?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！