Sample Header Ad - 728x90

RUNNING SQL file taking longer

-1 votes
1 answer
53 views
We are getting a .sql file with 152K records and when trying to run this file using unix script with below command, is taking almost an hour. is there any way to reduce the time. SQL FileName : Running_Long.sql Content : around 152k records like below go if exists (select * from table1 where id = 11111) update table2 set id2 = 66666 where id = 55555 go if exists (select * from table1 where id = 22222) update table2 set id2 = 77777 where id = 44444 go ... ... go if exists (select * from table1 where id = 33333) update table2 set id2 = 88888 where id = 99999 go sql command running from the script: Sybase isql -Uuser -Ppass -e -n -i Running_Long.sql -o logfile Thank you
Asked by Venu Vakul (1 rep)
Feb 6, 2025, 01:27 AM
Last activity: Feb 6, 2025, 08:22 AM