hi all,
any help would be appreciated with the following problem. Im running a large sqr ver 4.3 against Oracle 8 on an Nt machine and its taking 3 hours to run. Ill have to run this frequently and could do with better performance. Heres what Im doing.
Im selecting 250 fields from a table 6500 times and then writing the record out to a file. Ive tried to select all the fields in one procedure and have also tried 250 different begin and end selects within one procedure. Its slower the second way. I know the issue is with the selecting and not with writing out as I tested commenting the write procedure. Anyone got any suggestions for performance on such a large select.
Below is the basics of what Im doing.
Tia and fingers crossed coz its running at the moment.
Chad
begin-procedure get_num
begin-select
number &num ! There are 6500 numbers
do get_fields
from table1
end-select
end-procedure get_num
begin-procedure get_fields
begin-select
field1 &f1
field2 &f2
...
...
field250 &250
do write_file
from table2
where number = &num
end-select
end-procedure get_fields
begin_procedure write_file
string &f1 &f2 .... &f250 by ',' into $rec
write 1 from $rec
end-procedure write_file