简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

sql语句 大量占用内存的查询解决办法

WBOY
Release： 2016-06-07 17:48:22
Original
2043 people have browsed it

sql语句涉及到大量占用内存的查询（如排序和哈希操作），内存不够，需要排队等待资源造成的,这是很多开发者碰到的问题，今天提供一些处理方法，希望对你有用。

解决办法：

    A、优化语句，创建/使用合适的索引；

    B、解决第一个问题的方法，更新要查询表的索引分发统计，保证估计时间的正确性，UPDATE  STATISTICS 表名；

    C、增加内存。

    如果想手动设置查询超时，可以使用以下语句：

 代码如下 复制代码
sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
sp_configure 'query wait', 2147483647
GO
RECONFIGURE
GO
Related labels：
sql占用内存
source：php.cn
Previous article：sql 2000/2005几种分页方法 Next article：sql 获取当前日期的最大时间值
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
How to use laravel components with livewire lazy placeholder I want to add the skeleton of my laravel component inside a livewire3 placeholder What I h...
From 2024-04-06 20:02:10
0
2
543
What are the best practices for displaying version information in web applications? I'm developing a web application. What are the best practices for displaying version infor...
From 2024-04-06 19:13:16
0
2
476
The execution order of VueJS scheduling functions causes problems I'm trying to display a list of announcements (retrieved from API) on a page. I'm using a ...
From 2024-04-06 10:37:58
0
1
385
Make sure the table cell's container fills the entire height of the parent I'm trying to vertically align the content without using Flexbox, because there are some i...
From 2024-04-04 16:03:18
0
1
404
Combining HTTPS redirection with rewrite rules cannot add .php extension Hope someone can help. I want to remove the file extension (.php) from internal links, but...
From 2024-04-04 15:44:30
0
1
299
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！