Click here to Skip to main content
15,845,598 members
Home / Discussions / C#
   

C#

 
GeneralRe: How do you write a query for comparing SQL Server CE data? Pin
Gerry Schmitz5-Jun-21 9:33
mveGerry Schmitz5-Jun-21 9:33 
QuestionWhat is the best way for saving huge amount of data into SQL CE file while keeping data uniqueness? Pin
Alex Dunlop2-Jun-21 7:58
Alex Dunlop2-Jun-21 7: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 8:08
mveDave Kreskowiak2-Jun-21 8: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 8:13
Alex Dunlop2-Jun-21 8: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 8:48
Victor Nijegorodov2-Jun-21 8: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 8:50
mveDave Kreskowiak2-Jun-21 8: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 9:07
mveGerry Schmitz2-Jun-21 9: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 8:12
Alex Dunlop2-Jun-21 8:12 
I used a method that can do this work, but it gets slower as the data increases.
I have used Dictionary<string, string=""> class to detect duplicate values (Dictionary.ContainsKey()).
After that I take them into a DataTable and then into SQL CE file.
Each time I want to add new data into my SQL, I read all previous SQL data into a DataTable then take them into Dictionary<> and check new data for any duplicate values and if they were unique, adding process is continued as above.
The problem is that this method works fine and fast to some extent. As the data increase(for example more than 5000 rows in SQL), it gets some seconds to calculate the process.

modified 2-Jun-21 13:19pm.

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:22
mveDave Kreskowiak2-Jun-21 8:22 
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 8:34
Alex Dunlop2-Jun-21 8: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 8:43
mveDave Kreskowiak2-Jun-21 8: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 8:48
Alex Dunlop2-Jun-21 8: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 8:51
mveDave Kreskowiak2-Jun-21 8: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 9:00
mveGerry Schmitz2-Jun-21 9: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 9:02
mveDave Kreskowiak2-Jun-21 9: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 9:09
mveGerry Schmitz2-Jun-21 9: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 3:06
Alex Dunlop3-Jun-21 3: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 3:05
Alex Dunlop3-Jun-21 3: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 4:12
mveRichard MacCutchan3-Jun-21 4: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 22:41
mveRichard Deeming2-Jun-21 22:41 
QuestionHow to increase filtering speed in DataGridView? Pin
Alex Dunlop29-May-21 23:37
Alex Dunlop29-May-21 23:37 
SuggestionRe: How to increase filtering speed in DataGridView? Pin
Richard MacCutchan29-May-21 23:45
mveRichard MacCutchan29-May-21 23:45 
AnswerRe: How to increase filtering speed in DataGridView? Pin
OriginalGriff30-May-21 3:07
mveOriginalGriff30-May-21 3:07 
GeneralRe: How to increase filtering speed in DataGridView? Pin
Alex Dunlop31-May-21 1:58
Alex Dunlop31-May-21 1:58 
GeneralRe: How to increase filtering speed in DataGridView? Pin
OriginalGriff31-May-21 3:14
mveOriginalGriff31-May-21 3:14 

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.