sebasttien
02-14-2001, 04:55 AM
hi,
i try to insert element in two table with one relationship, the first table
is a table of flights the second is a table os stopovers. There 56000 flights
with one or two stopovers by flights. The file contains about 120000 line
of insert instruction like :
insert into vol(...) values(...)
go
insert into escale(...) values(...)
go
...
i do the isql command line to integrate this file :
isql /U login /d database /i filePath /o filelog /P password
the integration time is about 6 hours !!!
is it normal ? where is my error if not ? how can integrate data in SQL7
more quickly ?
thanks
regards
i try to insert element in two table with one relationship, the first table
is a table of flights the second is a table os stopovers. There 56000 flights
with one or two stopovers by flights. The file contains about 120000 line
of insert instruction like :
insert into vol(...) values(...)
go
insert into escale(...) values(...)
go
...
i do the isql command line to integrate this file :
isql /U login /d database /i filePath /o filelog /P password
the integration time is about 6 hours !!!
is it normal ? where is my error if not ? how can integrate data in SQL7
more quickly ?
thanks
regards