B
Bharat
Guest
There is a program in production to export audit data from audit tables. The performance of the program is very poor as it is running 4 hrs just to export 5GB data. Before giving the output data there was a out of disk space where the short/temp file was actually growing upto 16GB(too huge). Once a client connecting client-server succeeded then client session runs a query which requires a results-list srt temp-file on the server-side. So the problem here is am sure this srt file generation must have taken 3 to 3:30 hrs for the completion.
Now the question is Will this srt file data is unique for the same query? If yes then can we do something to use this srt file directly to generate the data? so that we can avoid srt file generating each time which will save us some time. I know its a stupid question but Just want to if its possible or not
Continue reading...
Now the question is Will this srt file data is unique for the same query? If yes then can we do something to use this srt file directly to generate the data? so that we can avoid srt file generating each time which will save us some time. I know its a stupid question but Just want to if its possible or not
Continue reading...