[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Improving SQR process "system calls" on UNIX while generating PDF files.
- Subject: Improving SQR process "system calls" on UNIX while generating PDF files.
- From: Thaî Le Tat <thai.le-tat@CREDITLYONNAIS.FR>
- Date: Fri, 28 Jun 2002 09:25:55 +0200
Environment (IBM Sequent / NUMAQ):
SQR Server/6.1.3/Sequent/DYNIX/ptx V4.4.6/Oracle 8.0.6/Oct 05 2000
I use SQR to produce 140000 PDF files.
My datas are readed from flat files, with no database I/O in my main loop.
I run "truss" to trace the system calls made by my sqr process, and get the
following :
[...]
- 1 call to open(<spf_file>) with file_descriptor (fd) 9 ,
- 170 calls to write() on fd 9, size 256 bytes,
- 250 to 256 calls to read() on fd 9 to get 1 byte,
- 1 write() on fd 9, size 255
- 7 open/read/close on file sqr.ini
- 1 small loop to convert the SPF file to a PDF file,
- 1 unlink on the SPF file.
[...]
This is repeated 140000 times.
My questions :
1/ how can I bypass the reload of my "sqr.ini" ?
2/ can I increase the size of the write-buffer (on spf) with a value larger
than 256 ?
3/ why does the sqr process perform 250 read to get 250 bytes from my spf ?
Any and all help would be appreciated.
Thanks.
Thai LE TAT
thai.le-tat@creditlyonnais.fr
Ce message contient des informations confidentielles ou appartenant au
Cr=e9dit Lyonnais et est =e9tabli =e0 l'intention exclusive de ses
destinataires. Toute divulgation, utilisation, diffusion ou reproduction
(totale ou partielle) de ce message, ou des informations qu'il contient,
doit =eatre pr=e9alablement autoris=e9e. Tout message =e9lectronique est
susceptible d'alt=e9ration et son int=e9grit=e9 ne peut =eatre assur=e9e.
Le Cr=e9dit Lyonnais d=e9cline toute responsabilit=e9 au titre de ce
message s'il a =e9t=e9 modifi=e9 ou falsifi=e9. Si vous n'=eates pas
destinataire de ce message, merci de le d=e9truire imm=e9diatement et
d'avertir l'exp=e9diteur de l'erreur de distribution et de la destruction
du message.
This e-mail contains confidential information or information belonging
to Cr=e9dit Lyonnais and is intended solely for the addressees.
The unauthorised disclosure, use, dissemination or copying (either whole
or partial) of this e-mail, or any information it contains, is prohibited.
E-mails are susceptible to alteration and their integrity cannot be guaranteed.
Cr=e9dit Lyonnais shall not be liable for this e-mail if modified or falsified.
If you are not the intended recipient of this e-mail, please delete it
immediately from your system and notify the sender of the wrong delivery
and the mail deletion.