Click here to Skip to main content
15,868,141 members
Home / Discussions / .NET (Core and Framework)
   

.NET (Core and Framework)

 
GeneralRe: Import Date values from Pipe-Delimited file to SQL Server table Pin
Richard MacCutchan5-Oct-17 3:51
mveRichard MacCutchan5-Oct-17 3:51 
AnswerRe: Import Date values from Pipe-Delimited file to SQL Server table Pin
Gerry Schmitz4-Oct-17 6:02
mveGerry Schmitz4-Oct-17 6:02 
GeneralRe: Import Date values from Pipe-Delimited file to SQL Server table - able to achieve but a small issue still remaining Pin
indian1434-Oct-17 7:06
indian1434-Oct-17 7:06 
QuestionImprove the performance of the reading of Excel Files using interop Pin
indian1433-Oct-17 11:45
indian1433-Oct-17 11:45 
AnswerRe: Improve the performance of the reading of Excel Files using interop Pin
Dave Kreskowiak3-Oct-17 13:42
mveDave Kreskowiak3-Oct-17 13:42 
AnswerRe: Improve the performance of the reading of Excel Files using interop Pin
Gerry Schmitz4-Oct-17 5:37
mveGerry Schmitz4-Oct-17 5:37 
SuggestionRe: Improve the performance of the reading of Excel Files using interop Pin
Richard Deeming4-Oct-17 9:15
mveRichard Deeming4-Oct-17 9:15 
AnswerRe: Improve the performance of the reading of Excel Files using interop Pin
Patrice T7-Oct-17 15:43
mvePatrice T7-Oct-17 15:43 
You need to learn program profiling: Profiling (computer programming) - Wikipedia[^]
With a profiler program, you will spot the parts where the computer spend time.
If you don't have such tool, as simple benchmark and runs with changing some values (number of rows and columns) will give you hints.
You will discover that runtime is linear with row numbers, but that it is not with column numbers.
You will see that runtime turn ugly as columns increase. The problem comes from the way you build the string inside the column loop.
Think about your code, and about the reason you do what you do, is it really needed?
Search if there is another way to things.
Patrice

“Everything should be made as simple as possible, but no simpler.” Albert Einstein

QuestionArranging the box concept Pin
Member 1289648327-Sep-17 4:29
Member 1289648327-Sep-17 4:29 
AnswerRe: Arranging the box concept Pin
Pete O'Hanlon27-Sep-17 4:31
subeditorPete O'Hanlon27-Sep-17 4:31 
AnswerRe: Arranging the box concept Pin
Eddy Vluggen27-Sep-17 5:30
professionalEddy Vluggen27-Sep-17 5:30 
QuestionConverting 32 bit Excel Files to 64 bit Excel files Programatically Pin
indian14326-Sep-17 6:53
indian14326-Sep-17 6:53 
AnswerRe: Converting 32 bit Excel Files to 64 bit Excel files Programatically Pin
Richard Deeming26-Sep-17 7:28
mveRichard Deeming26-Sep-17 7:28 
QuestionNeed to find out which versions of the Oracle and Office Drivers are installed on my machine Pin
indian14321-Sep-17 10:18
indian14321-Sep-17 10:18 
AnswerRe: Need to find out which versions of the Oracle and Office Drivers are installed on my machine Pin
Gerry Schmitz21-Sep-17 12:44
mveGerry Schmitz21-Sep-17 12:44 
GeneralRe: Need to find out which versions of the Oracle and Office Drivers are installed on my machine Pin
Peter R. Fletcher14-Oct-17 11:24
Peter R. Fletcher14-Oct-17 11:24 
QuestionConvert String to HEX Format Represents a 32-Bit Signed Integer Pin
chr1s211-Sep-17 1:40
chr1s211-Sep-17 1:40 
AnswerRe: Convert String to HEX Format Represents a 32-Bit Signed Integer Pin
Richard Deeming1-Sep-17 2:34
mveRichard Deeming1-Sep-17 2:34 
GeneralRe: Convert String to HEX Format Represents a 32-Bit Signed Integer Pin
chr1s211-Sep-17 4:07
chr1s211-Sep-17 4:07 
GeneralRe: Convert String to HEX Format Represents a 32-Bit Signed Integer Pin
jschell18-Sep-17 12:24
jschell18-Sep-17 12:24 
GeneralRe: Convert String to HEX Format Represents a 32-Bit Signed Integer Pin
Richard Deeming19-Sep-17 1:35
mveRichard Deeming19-Sep-17 1:35 
GeneralRe: Convert String to HEX Format Represents a 32-Bit Signed Integer Pin
jschell20-Sep-17 5:08
jschell20-Sep-17 5:08 
QuestionCannot load multiple layers of SWF with Axshockwaveflash due to Adobe Flash security updates Pin
Member 1150681831-Aug-17 19:32
Member 1150681831-Aug-17 19:32 
AnswerRe: Cannot load multiple layers of SWF with Axshockwaveflash due to Adobe Flash security updates Pin
Richard MacCutchan31-Aug-17 20:56
mveRichard MacCutchan31-Aug-17 20:56 
GeneralRe: Cannot load multiple layers of SWF with Axshockwaveflash due to Adobe Flash security updates Pin
Member 1150681831-Aug-17 21:35
Member 1150681831-Aug-17 21:35 

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.