@bhupeshpanwar wrote:
Thanks Tom. I knew I was doing something silly.
What exactly does sharedbuffers do? Will it help with the processing time if I intend to use it?
It means that the locations in memory and the INFILE and FILE statements use to store the data being read/written to the disk are the same. It could impove the performance. But the risk is that if it doesn't work right you have corrupted the original file.
If the file is not large (smaller than say 20 Gigabytes) then the performance increase is not worth the risk.
The code you posted will not work without using SHAREDBUFFERS because it it not explicitly re-writing each character. Use the modified code I posted instead.
... View more