Strange MariaDB save problem.

[vilian]

Do you have a index for field IC_NO on table icbelge ?

[Horizon]

Do you have a index for field IC_NO on table icbelge ?

Yes you are right. I forgot the index when I transferred from dbf to test many times.

Thanks.

[nageswaragunupudi]

1) Please make sure every table has a single column primary key.
2) Fields you use in WHERE clause need to be either primary key or indexed fields.

3) Also use this statement before starting your loop:

Code: Select all

oCn:SetAutoCommit( .f. )
 

After end of loop

Code: Select all

oCn:SetAutoCommit( .t. )
 

4) Such large export of data should be attempted on local server.

5) Increase max_allowed_packetsize suitably and concatenate more than one update statement with ";" so that the total size of the combined sql does not exceed 80% of the max_allowed_packetsize. Then execute multiple query at a time instead of executing each update query separately.