从大表数据中选择时如何加快从大表数据中检索数据的速度？ [英] How to speed retrieving data from big table data when select from it?

问题描述

问题



当新的SQL查询计算机中的选择数据挂起时，我的表有20列？



有什么建议可以快速读取此表中的数据并使性能更好？





计算机能力



==============



i的SQL工作服务器2012.



从这个表中选择数据挂起电脑，虽然我的电脑功能还不错



ram 8 GIGA和处理器核心I 5。



我在另一台计算机上尝试相同的数据备份它需要花费太多时间吗？



==============



如果可能的话，建议从表中快速选择数据和最佳性能？



我的尝试：

我尝试的是什么
 
 ========== 
 
选择*从表中1 = 1需要45分钟
 
最小化后列nu mber为
 
从表中选择第1列第2列第3列也会挂起但是花费的时间少于42分钟。 
 
当从表中选择数据时，其他程序只打开SQL服务器打开新查询。 
 
表有100万条记录。

解决方案

引用：

从表中选择*，其中1 = 1需要45分钟

表有100万条记录。

您正在选择单个选择中有100万条记录，你想知道为什么需要时间？

你需要一个真正更快的服务器和一个非常快速的网络。

或者学习数据库设计。



PS：99问题后，您仍然不知道哪些信息对我们有用。

您的查询检索全部来自一张桌子的1,000,000条记录，你想知道为什么需要这么长时间？问题是你从桌子上检索了1,000,000条记录！



你的机器规格并不意味着该死的东西。



您的数据库设计，索引，如何使用数据以及您正在进行处理的位置需要进行审核，并且可能从头开始重新设计以提高性能。

我相信我们认为的计划。

如果我给1公斤米饭放置距离。你会很快。

如果我给100公斤大米，那么你需要时间。

在单次时间内无法携带，所以你会尝试移动4次尝试取决于你的容量。



如果你真的需要进行一次尝试，你必须通过购买Minnie卡车来增加容量。



在程序中也是如此..或者你可以保存像年份一样的数据表

Problem

I have table have 20 columns when make select data from new SQL query computer hangs ?

what suggestion to make quickly read data from this table and make performance good ?


Computer Capability

==============

i work on SQL server 2012.

select data from this table hangs computer although my computer capability not bad

ram 8 GIGA and processor core I 5 .

I try same Backup of data on another computer it take too much time as above ?

==============

if possible what suggestions to select data quickly from table and best performance ?

What I have tried:

What I Try 

==========

select * from table where 1=1 take 45 minutes 

after minimize column number as 

select column 1,column 2,column 3 from table also hangs but take less time as 42 minutes .

when make select data from tables not other programs open only SQL server opened new query.

table have 1 million records .

解决方案

Quote:

select * from table where 1=1 take 45 minutes
table have 1 million records .

You are selecting 1 million records in a single select and you wonder why it takes time ?
You need a really faster server and a really fast network too.
Or learn database design.

PS: After 99 question, you still don't know what information are useful to us.

Your query is retrieving all 1,000,000 records from a table and you wonder why it takes so long? The problem is you're retrieving 1,000,000 records from a table!

Your machine spec's don't mean a damn thing.

Your database design, indexing, how you're using the data, and where you're doing the processing needs to be reviewed and probably redesigned from the ground up to improve performance.

i believe as program as we think.
if i give 1kg of rice to place at distance. u will be as quick as.
if i give to 100kg of rice then u will take time.
in Single time its not possible to carry , so u will try to move in 4 attempt depends on ur capacity.

if your really need to carry in one attempt in you have to increase capacity by buying Minnie truck.

as same in program also.. or you can save data like year wise in one table.

这篇关于从大表数据中选择时如何加快从大表数据中检索数据的速度？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！