Hi Alexandre

I am surprised the problem is with .next itself. So - some fundamental
questions
Does the cursor have its own TIB_Connection and TIB_session created in the
thread?
Do you free the cursor and associated objects when each thread finished?
Do you use memory locks to get the data from the thread?
Do you know how many threads ar running and is it stable or growing rapidly?
if you dont know - try and monitor it.

Regards
Paul

> -----Original Message-----
> From: IBObjects@yahoogroups.com
> [mailto:IBObjects@yahoogroups.com] On Behalf Of Alexandre
> Sent: 03 November 2008 12:25
> To: IBObjects@yahoogroups.com
> Subject: [IBO] Problems with memory
>
> Hi Guys,
>
> I have a program with several thread running at the same
> time, each thread creates a tib_cursor with a query in sql
> like this: select * from My_table
>
> The problem is that every time I run a command
> tibcursor.next, the memory consumed by the program increases,
> until the program crash with the message: "Thread creation
> error: Not enough storage is available to process this command"
>
> is there any way to avoid the increase of memory made by tib_cursor ?
>
> Thx
> Alexandre
> Brazil
>
> [Non-text portions of this message have been removed]
>
>
> ------------------------------------
>
> ______________________________________________________________
> _____________
> IB Objects - direct, complete, custom connectivity to
> Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ______________________________________________________________
> _____________
> http://www.ibobjects.com - your IBO community resource for
> Tech Info papers,
> keyword-searchable FAQ, community code contributions and more
> ! Yahoo! Groups Links
>
>
>