Click here to Skip to main content
15,886,919 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

 
AnswerRe: Question on performance... Pin
Cpichols17-Oct-22 1:32
Cpichols17-Oct-22 1:32 
AnswerRe: Question on performance... Pin
charlieg17-Oct-22 2:27
charlieg17-Oct-22 2:27 
AnswerRe: Question on performance... Pin
MikeCO1017-Oct-22 3:03
MikeCO1017-Oct-22 3:03 
AnswerRe: Question on performance... Pin
Max Santos17-Oct-22 3:47
Max Santos17-Oct-22 3:47 
AnswerRe: Question on performance... Pin
GuyThiebaut17-Oct-22 5:54
professionalGuyThiebaut17-Oct-22 5:54 
AnswerRe: Question on performance... Pin
WildlingCoder17-Oct-22 6:38
professionalWildlingCoder17-Oct-22 6:38 
AnswerRe: Question on performance... Pin
JasonSQ17-Oct-22 8:44
JasonSQ17-Oct-22 8:44 
AnswerRe: Question on performance... Pin
englebart17-Oct-22 17:02
professionalenglebart17-Oct-22 17:02 
  1. Figure out the bottle neck.
Since it does not happen in Dev, but does in production, I suspect it is the duplicate checking. If you size dev the same as production will it reproduce in dev?

Also, do you have more fault tolerance/active nodes in production? If you are doing a few thousand small transactions in a high availability setup, it will take longer.

Do you perform all of your duplicate checks in a single query? Or one import row at a time?

If you setup good, unique indexes, then you can skip the duplicate checking and let the DB do it for you. This would point you toward a commit per import row.

We had an import feature that ended up with an unnecessary exponential complexity. It was fine during testing but started getting really slow at only 150 rows.
Generalworldle 267 Pin
jmaida15-Oct-22 8:59
jmaida15-Oct-22 8:59 
GeneralWordle 484 Pin
Vivi Chellappa15-Oct-22 8:41
professionalVivi Chellappa15-Oct-22 8:41 
GeneralRe: Wordle 484 Pin
Peter_in_278015-Oct-22 11:27
professionalPeter_in_278015-Oct-22 11:27 
GeneralRe: Wordle 484 3/6 Pin
jmaida16-Oct-22 12:33
jmaida16-Oct-22 12:33 
GeneralRe: Wordle 484 Pin
StarNamer@work15-Oct-22 13:21
professionalStarNamer@work15-Oct-22 13:21 
GeneralRe: Wordle 484 Pin
Amarnath S15-Oct-22 14:19
professionalAmarnath S15-Oct-22 14:19 
GeneralRe: Wordle 484 Pin
megaadam15-Oct-22 15:51
professionalmegaadam15-Oct-22 15:51 
GeneralRe: Wordle 484 Pin
OriginalGriff15-Oct-22 18:44
mveOriginalGriff15-Oct-22 18:44 
GeneralRe: Wordle 484 Pin
Sandeep Mewara15-Oct-22 19:16
mveSandeep Mewara15-Oct-22 19:16 
GeneralRe: Wordle 484 Pin
Sander Rossel15-Oct-22 20:28
professionalSander Rossel15-Oct-22 20:28 
GeneralRe: Wordle 484 Pin
pkfox16-Oct-22 4:59
professionalpkfox16-Oct-22 4:59 
GeneralI'm failing terrible on this... Pin
0x01AA15-Oct-22 8:07
mve0x01AA15-Oct-22 8:07 
GeneralThe adjective for metal is metallic... Pin
Sander Rossel15-Oct-22 2:50
professionalSander Rossel15-Oct-22 2:50 
GeneralRe: The adjective for metal is metallic... Pin
PIEBALDconsult15-Oct-22 3:03
mvePIEBALDconsult15-Oct-22 3:03 
JokeRe: The adjective for metal is metallic... Pin
englebart15-Oct-22 7:59
professionalenglebart15-Oct-22 7:59 
JokeRe: The adjective for metal is metallic... Pin
Daniel Pfeffer15-Oct-22 8:35
professionalDaniel Pfeffer15-Oct-22 8:35 
GeneralRe: The adjective for metal is metallic... Pin
jmaida15-Oct-22 16:29
jmaida15-Oct-22 16:29 

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.