| From: | Roberto Fichera <robyf(at)tekno-soft(dot)it> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Acucobol interface |
| Date: | 2001-05-31 16:26:17 |
| Message-ID: | 5.1.0.14.2.20010531174557.02b40c10@mail.tekno-soft.it |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi All,
I'm developing (currently in pre-alfa stage) a Acucobol interface for the
Postgresql.
The Acucobol runtime have a generic FS API interface that handle the work
with the
record oriented files, defining the open, close, read, write and so on low
level function I can
extend the runtime to talk with any file and database.
My current work translate each Acucobol FS command in a relative Postgresql
query and
the returned tuple will be translated in a record oriented view.
After some performance tests I've notice that this path have much overhead
and because
this I was thinking to redesign the interface.
My first think was to bypass the SQL translation and use the Postgresql low
level routines.
I need to see the tables as record oriented archive, so I can scan
sequentially (forward and
backward) each record, lock/unlock it, insert and delete it and start to
read the records with
a match of a specific key.
Does anyone know where can I start to search/read/learn/study some
document/code of the
Postgresql low level routines ?
If need some detail, please ask ;-)!
Thanks in advance.
Roberto Fichera.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-05-31 16:29:36 | Re: ERROR: cache lookup for proc 43030134 failed |
| Previous Message | Jan Wieck | 2001-05-31 16:20:38 | Access statistics |