Sql server通过C＃winforms app搜索大量数据 [英] Sql server searching in huge data by C# winforms app

问题描述

这个问题仅仅是为了满足，因为它是我的第一个处理数据库的应用程序，

我是数据库的初学者，我建立了一个包含（或将包含）巨大的公司会计系统多年后的记录挂载，

我开发了ac＃win表单应用程序作为用户界面和sql server 2014数据库，

我例如当用户搜索特定的所有现金交易时今年它将是一大堆将在Datagridview中加载的记录，

或者当搜索特定发票时系统将搜索它（使用SELECT语句）将搜索大量记录，

测试一些数据时数据处理性能良好

我只是想确保程序在插入数据多年后保持相同的性能



我尝试了什么：



我想在使用程序时避免任何未来的问题

如果有人可以帮助我关于搜索大量数据的信息并给我数字例如

解决方案

我的建议是看一下 VirtualMode 属性。

在这里看一个例子：演练：在Windows窗体DataGridView控件中实现虚拟模式 [ ^ ]



我还建议使用 PostgreSQL （使用 NpgSql C＃驱动程序而不是 SQL Server ，我们发现使用运行时，我们的应用程序在使用大数据时表现更好的PostgreSQL

This question is just for contentment, because it's my first application that deals with databases,
I'm beginner in databases, I build a company accountant system that contains (or will contain) a huge mount of records after years,
I developed a c# win forms application as user interface and sql server 2014 database,
I for example when user search for all cash transactions for specific year it will be a huge mount of records that will loaded in Datagridview,
Or when search for specific invoice the system will search for it( using SELECT statement) will search in huge mount of records,
Data handling performance is good when testing on a few data
I just want to make sure that the program will stay in the same performance after years of inserting data

What I have tried:

I want to avoid any future problem while using the program
If anyone can help me with informations about searching in huge data and give me numbers for example

解决方案

My advice is to take a look at the VirtualMode property.
Look here for an example: Walkthrough: Implementing Virtual Mode in the Windows Forms DataGridView Control[^]

Also I can recommend using PostgreSQL (with the NpgSql driver for C#) instead of SQL Server, we found our application performed significantly better with big data when running with PostgreSQL.

这篇关于Sql server通过C＃winforms app搜索大量数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！