Click here to Skip to main content
16,017,638 members
Home / Discussions / C#
   

C#

 
QuestionWhat is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Alex Dunlop2-Jun-21 6:58
Alex Dunlop2-Jun-21 6:58 
AnswerRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Dave Kreskowiak2-Jun-21 7:08
mveDave Kreskowiak2-Jun-21 7:08 
GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Alex Dunlop2-Jun-21 7:13
Alex Dunlop2-Jun-21 7:13 
GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Victor Nijegorodov2-Jun-21 7:48
Victor Nijegorodov2-Jun-21 7:48 
GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Dave Kreskowiak2-Jun-21 7:50
mveDave Kreskowiak2-Jun-21 7:50 
GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Gerry Schmitz2-Jun-21 8:07
mveGerry Schmitz2-Jun-21 8:07 
AnswerRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Alex Dunlop2-Jun-21 7:12
Alex Dunlop2-Jun-21 7:12 
GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Dave Kreskowiak2-Jun-21 7:22
mveDave Kreskowiak2-Jun-21 7:22 
And this is why I said do it in a stored procedure in the database.

For every record you want to insert, why on earth would you read all of the existing data? Yes, this get's slower and slower every time you insert a record. All that data transfer will take more and more time.

It sounds like you're not even caching the data you read and insert! If you're going to do something like this, you would normally just read the database once, keep all that data, then add new records to the cache and have the cache update the database.

This has a downside though. You really cannot use it in a multi-user environment, and there is a limit to the amount of data you can keep in memory, so it doesn't scale well at all.

Doing it in the database removes reading all that data over and over again, and removes the memory size limits.

DO IT IN THE DATABASE WITH A STORED PROCEDURE!

GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Alex Dunlop2-Jun-21 7:34
Alex Dunlop2-Jun-21 7:34 
GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Dave Kreskowiak2-Jun-21 7:43
mveDave Kreskowiak2-Jun-21 7:43 
GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Alex Dunlop2-Jun-21 7:48
Alex Dunlop2-Jun-21 7:48 
GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Dave Kreskowiak2-Jun-21 7:51
mveDave Kreskowiak2-Jun-21 7:51 
GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Gerry Schmitz2-Jun-21 8:00
mveGerry Schmitz2-Jun-21 8:00 
GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Dave Kreskowiak2-Jun-21 8:02
mveDave Kreskowiak2-Jun-21 8:02 
GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Gerry Schmitz2-Jun-21 8:09
mveGerry Schmitz2-Jun-21 8:09 
GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Alex Dunlop3-Jun-21 2:06
Alex Dunlop3-Jun-21 2:06 
GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Alex Dunlop3-Jun-21 2:05
Alex Dunlop3-Jun-21 2:05 
GeneralRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Richard MacCutchan3-Jun-21 3:12
mveRichard MacCutchan3-Jun-21 3:12 
AnswerRe: What is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Richard Deeming2-Jun-21 21:41
mveRichard Deeming2-Jun-21 21:41 
QuestionHow to increase filtering speed in DataGridView? Pin
Alex Dunlop29-May-21 22:37
Alex Dunlop29-May-21 22:37 
SuggestionRe: How to increase filtering speed in DataGridView? Pin
Richard MacCutchan29-May-21 22:45
mveRichard MacCutchan29-May-21 22:45 
AnswerRe: How to increase filtering speed in DataGridView? Pin
OriginalGriff30-May-21 2:07
mveOriginalGriff30-May-21 2:07 
GeneralRe: How to increase filtering speed in DataGridView? Pin
Alex Dunlop31-May-21 0:58
Alex Dunlop31-May-21 0:58 
GeneralRe: How to increase filtering speed in DataGridView? Pin
OriginalGriff31-May-21 2:14
mveOriginalGriff31-May-21 2:14 
GeneralRe: How to increase filtering speed in DataGridView? Pin
Alex Dunlop31-May-21 3:59
Alex Dunlop31-May-21 3:59 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.