Click here to Skip to main content
14,266,166 members
   

Database

 
GeneralRe: MongoDB via WebAPI Question Pin
Kevin Marois31-May-19 7:25
professionalKevin Marois31-May-19 7:25 
GeneralRe: MongoDB via WebAPI Question Pin
Nathan Minier31-May-19 8:03
professionalNathan Minier31-May-19 8:03 
GeneralRe: MongoDB via WebAPI Question Pin
Kevin Marois31-May-19 8:38
professionalKevin Marois31-May-19 8:38 
GeneralRe: MongoDB via WebAPI Question Pin
Nathan Minier31-May-19 8:51
professionalNathan Minier31-May-19 8:51 
AnswerRe: MongoDB via WebAPI Question Pin
#realJSOP10-Jun-19 5:19
mve#realJSOP10-Jun-19 5:19 
GeneralRe: MongoDB via WebAPI Question Pin
Kevin Marois10-Jun-19 5:23
professionalKevin Marois10-Jun-19 5:23 
QuestionDebug a procedure in Oracle which feeds into crystal report Pin
Member 1447460729-May-19 5:13
memberMember 1447460729-May-19 5:13 
AnswerRe: Debug a procedure in Oracle which feeds into crystal report Pin
Jörgen Andersson29-May-19 9:15
protectorJörgen Andersson29-May-19 9:15 
GeneralRe: Debug a procedure in Oracle which feeds into crystal report Pin
Member 1447460731-May-19 5:49
memberMember 1447460731-May-19 5:49 
GeneralRe: Debug a procedure in Oracle which feeds into crystal report Pin
Qingyong Yu16-Jul-19 18:51
memberQingyong Yu16-Jul-19 18:51 
NewsMessage Closed Pin
28-May-19 5:51
memberMember 1447108128-May-19 5:51 
QuestionCentOS6.9 (MySql v5.7.22) use mysql C API mysql_real_query cause the memory always growing Pin
normga23-May-19 3:13
membernormga23-May-19 3:13 
AnswerRe: CentOS6.9 (MySql v5.7.22) use mysql C API mysql_real_query cause the memory always growing Pin
jschell23-May-19 6:41
memberjschell23-May-19 6:41 
GeneralRe: CentOS6.9 (MySql v5.7.22) use mysql C API mysql_real_query cause the memory always growing Pin
normga23-May-19 9:27
membernormga23-May-19 9:27 
GeneralRe: CentOS6.9 (MySql v5.7.22) use mysql C API mysql_real_query cause the memory always growing Pin
jschell2-Jun-19 8:25
memberjschell2-Jun-19 8:25 
QuestionBest way to batchprocess a large update Pin
Jörgen Andersson23-May-19 2:09
protectorJörgen Andersson23-May-19 2:09 
AnswerRe: Best way to batchprocess a large update Pin
Richard Deeming23-May-19 7:38
mveRichard Deeming23-May-19 7:38 
GeneralRe: Best way to batchprocess a large update Pin
Jörgen Andersson23-May-19 7:52
protectorJörgen Andersson23-May-19 7:52 
GeneralRe: Best way to batchprocess a large update Pin
Jörgen Andersson23-May-19 22:08
protectorJörgen Andersson23-May-19 22:08 
GeneralRe: Best way to batchprocess a large update Pin
Richard Deeming24-May-19 0:44
mveRichard Deeming24-May-19 0:44 
GeneralRe: Best way to batchprocess a large update Pin
Jörgen Andersson24-May-19 1:45
protectorJörgen Andersson24-May-19 1:45 
Richard Deeming wrote:
When you use the TOP clause with the UPDATE statement, there's no guarantee that the rows to update will be picked in any particular order. Using the MAX(id) option, you could end up missing rows.

I know, and you can't add an order by to an UPDATE or INSERT.
But you can put the SELECT with TOP and ORDER BY in a CTE.
Richard Deeming wrote:
I notice you've replaced the temporary table with a table variable. Was there a reason for that?

No particular reason. I like to keep the scope as local as possible, so it's mostly a habit.
Richard Deeming wrote:
IIRC, execution plans for table variables tend to assume they contain a very low number of rows, which might explain the poor performance.

Table variables don't have statistics, which obviously could affect the plan, but since all ID's are unique I don't think it would make a big difference in this case

But I will test it.

<edit>Oh, and table variables can't go parallell, which obviously can affect performance a lot in this case.</edit>
Wrong is evil and must be defeated. - Jeff Ello

GeneralRe: Best way to batchprocess a large update Pin
Jörgen Andersson26-May-19 23:17
protectorJörgen Andersson26-May-19 23:17 
AnswerRe: Best way to batchprocess a large update Pin
Eddy Vluggen24-May-19 0:04
mveEddy Vluggen24-May-19 0:04 
GeneralRe: Best way to batchprocess a large update Pin
Jörgen Andersson24-May-19 1:24
protectorJörgen Andersson24-May-19 1:24 
AnswerRe: Best way to batchprocess a large update Pin
#realJSOP29-May-19 0:43
mve#realJSOP29-May-19 0:43 

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.