Click here to Skip to main content
15,867,568 members
Home / Discussions / Database
   

Database

 
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
jschell23-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
normga23-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
jschell2-Jun-19 8:25 
QuestionBest way to batchprocess a large update Pin
Jörgen Andersson23-May-19 2:09
professionalJö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
professionalJörgen Andersson23-May-19 7:52 
GeneralRe: Best way to batchprocess a large update Pin
Jörgen Andersson23-May-19 22:08
professionalJö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 
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 notice you've replaced the temporary table with a table variable. Was there a reason for that? IIRC, execution plans for table variables tend to assume they contain a very low number of rows, which might explain the poor performance.



"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

GeneralRe: Best way to batchprocess a large update Pin
Jörgen Andersson24-May-19 1:45
professionalJörgen Andersson24-May-19 1:45 
GeneralRe: Best way to batchprocess a large update Pin
Jörgen Andersson26-May-19 23:17
professionalJörgen Andersson26-May-19 23:17 
AnswerRe: Best way to batchprocess a large update Pin
Eddy Vluggen24-May-19 0:04
professionalEddy Vluggen24-May-19 0:04 
GeneralRe: Best way to batchprocess a large update Pin
Jörgen Andersson24-May-19 1:24
professionalJö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 
GeneralRe: Best way to batchprocess a large update Pin
Richard Deeming29-May-19 0:52
mveRichard Deeming29-May-19 0:52 
GeneralRe: Best way to batchprocess a large update Pin
#realJSOP29-May-19 1:06
mve#realJSOP29-May-19 1:06 
GeneralRe: Best way to batchprocess a large update Pin
Richard Deeming29-May-19 1:12
mveRichard Deeming29-May-19 1:12 
GeneralRe: Best way to batchprocess a large update Pin
#realJSOP29-May-19 1:20
mve#realJSOP29-May-19 1:20 
GeneralRe: Best way to batchprocess a large update Pin
Jörgen Andersson29-May-19 2:59
professionalJörgen Andersson29-May-19 2:59 
GeneralRe: Best way to batchprocess a large update Pin
#realJSOP29-May-19 5:13
mve#realJSOP29-May-19 5:13 
AnswerRe: Best way to batchprocess a large update Pin
#realJSOP29-May-19 1:14
mve#realJSOP29-May-19 1:14 
GeneralRe: Best way to batchprocess a large update Pin
Jörgen Andersson29-May-19 3:01
professionalJörgen Andersson29-May-19 3:01 
QuestionMongoDB Int Primary Key Pin
Kevin Marois17-May-19 8:41
professionalKevin Marois17-May-19 8:41 
AnswerRe: MongoDB Int Primary Key Pin
jschell18-May-19 7:09
jschell18-May-19 7:09 
GeneralRe: MongoDB Int Primary Key Pin
Kevin Marois20-May-19 6:21
professionalKevin Marois20-May-19 6:21 
GeneralRe: MongoDB Int Primary Key Pin
jschell23-May-19 5:33
jschell23-May-19 5:33 

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.