Do you have a index for field IC_NO on table icbelge ?
vilian wrote: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.
FiveTech Support Forums
FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour Strange MariaDB save problem.
Page: 1 2 (18 posts)
Yes you are right. I forgot the index when I transferred from dbf to test many times.
Thanks.
Regards,
Hakan ONEMLI
Harbour & MSVC 2022 & FWH 23.06
Hakan ONEMLI
Harbour & MSVC 2022 & FWH 23.06
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:
After end of loop
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.
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:
oCn:SetAutoCommit( .f. )After end of loop
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.
Regards
G. N. Rao.
Hyderabad, India
G. N. Rao.
Hyderabad, India
Page: 1 2 (18 posts)