大数据会影响整体应用程序的性能吗？ [英] does large data affect the performance of overall application?

问题描述

大家好，



我有一个Web应用程序，它将记录存储在数据库中。它有50到60个表，但数据存储频率仅在6到7个表中很高。其他表类似于主表并具有修复数据。现在我还有一个用于审计这些6到7个表的表的表，它存储了表的每个字段值以进行插入，更新和删除操作。因此，与其他表相比，这个表基本上会大规模增长。



但是这些审计试验数据通常较少使用，仅用于备份/安全目的。



现在我的查询是，如果我们在此审计试验数据调用时应用正确的选择查询，而不是数据库中的大数据（更多内存大小为mdf / ldf文件） ，它是否会影响应用程序的整体性能？

Hi All,

I have an web application which stored record in the database. it has 50 to 60 tables but frequency of data storage is high only on 6 to 7 tables. other tables are like master table and have fix data. Now i have one more table for audit trial of these 6 to 7 tables and it stored each field value of table for insert , update and delete operation. So, basically this table grows on a large scale as compare to other tables.

However these audit trial data generally used less and only for back up / security purpose.

Now my query is if we apply proper select query when this audit trial data call than apart from large data (more memory size for mdf / ldf file) in the database , does it affect the overall performance of the application?

推荐答案

答案是它取决于，因为很多因素，例如你如何编写代码和你正在对数据做了什么以及有多少。您是否在与应用程序相同的计算机上设置SQL Server？配置是否正确？您的数据库构建得当吗？正确索引？是否涉及任何数据缓存？问题和可能性列表似乎无穷无尽。实际上没有办法给你一个具体的答案。

The answer is "it depends", on lots of factors such as how you're writing your code and exactly what you're doing with the data and how much of it. Are you setting up the SQL Server on the same machine as the application? Is it configured properly? Is your database constructed appropriately? Correct indexing? Is there any caching of data involved? The list of questions and possibilities is seemingly endless. There is really no way to give you a concrete answer.

它应该影响一点但不要太多......如果确实如此，那么在表格上应用适当的索引

It should affect a little but not too much... If it does then apply proper indexes on the tables

如果您使用gridview或一次加载所有数据，那么它会影响性能，您可以使用自定义分页。

If you are using gridview or loading all data in once than it will affect performance in that case you can use Custom paging.

这篇关于大数据会影响整体应用程序的性能吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！