Hello friends
I need to update 25,000 records from the database.
But after 5,000 records, the speed of this operation drops sharply !!
What is the cause of the slowdown?
Thank you.
I need to update 25,000 records from the database.
But after 5,000 records, the speed of this operation drops sharply !!
What is the cause of the slowdown?
Thank you.
B4X:
For i=1 To 25000
Log(i)
If File.Exists("C:\Users\User\Desktop\"&verb_type&"\",i&"-"&verb_type&".HTML") Then
master_html = File.ReadString("C:\Users\User\Desktop\"&verb_type&"\",i&"-"&verb_type&".HTML")
sql1.ExecNonQuery2("UPDATE tbl_master SET html_"&verb_type&" = ?,special_json_"&verb_type&" = ?,master_json_"&verb_type&" = ? WHERE id = ?", Array As Object(master_html,get_json_spechal,get_json,i))
Else
TextArea1.Text=TextArea1.Text&CRLF&i
End If
Next