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.


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl

Reply via email to