Sql server searching in huge data by C# winforms app

Question

1.00/5 (1 vote)

See more:

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

Posted 25-May-17 7:11am

XRushdy

Updated 25-May-17 8:51am

v2

Add a Solution

Comments

[no name] 25-May-17 13:14pm

It's a pretty safe bet that none of us can foretell the future.

ZurdoDev 25-May-17 13:47pm

Step 1: Make sure you are Paging the data.

CHill60 26-May-17 4:55am

A virtual 5*!

Maciej Los 25-May-17 15:48pm

When someone is talking about the measurement, i always ask: what you mean by saying "huge". Can you tell us how much is "huge"?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RickZeeland · Accepted Answer · 2017-05-25T08:51:00

Solution 1

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.

Posted 25-May-17 8:51am

RickZeeland

Updated 25-May-17 9:04am

v2

Comments

Maciej Los 25-May-17 15:44pm

In your opinion, Rick, PostgreSQL is better than MS SQL Server? Partially agree, especially when we talk about number of OS'es which can be used with PostgreeSQL. But the other... Take a look at this ranking: Microsoft SQL Server vs. PostgreSQL Comparison[^]?
BTW: A 5 for the link.

RickZeeland 25-May-17 15:55pm

It depends on your needs, if you need a lot of bells and whistles SQL Server certainly beats PostgreSQL, but for performance and ease of distribution with an application I think PostgreSQL is way better.
I looked at your link with the ranking but the lower score of PostgreSQL does not convince me that SQL Server is better, when you look closer you see that the score is based on "popularity" and not on benchmarks !
Here is an interesting comparison of SQL Server and PostgreSQL: https://www.pg-versus-ms.com/ and also here: https://www.reddit.com/r/programming/comments/2mhpwp/postgresql_vs_ms_sql_server_a_comparison_of_two/

Maciej Los 26-May-17 1:47am

Good to know ;)
Cheers
Maciej