Hi Norbert,I have developed an access layer using OpenDBX. It is very logical and well thought out - thank you.
My testing has been restricted to Firebird so far and I have discovered a problem which I am not sure is something I'm doing wrong or is a bug in OpenDBX.
I have an application that polls for the existence of rows in a table every second by a select statement. It then processes them and deletes them. 99% of the time, no rows are available.
An *odbx_result_finish* is always when I exit.The problem is that each poll (select statement) results in the server allocating 128KB that is not released. Needless to say that after a while, the server runs out of memory.
I have tried using a Firebird selectable stored procedure as well as a normal DSQL statement with the same result.
Are you aware of any problems with the Firebird backend or suggest what I can do to fix or diagnose the problem?
Kind regards, Mark Lamberton Sydney Australia
<<attachment: mark.vcf>>
------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev
_______________________________________________ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
