Memory Issues

[Ivan Smahin]

On 3/29/2011 7:06 AM, Warren Kuhl wrote:
> After further testing my application, the only way free up memory 
> (that I can tell) is to close my database...which is done when I close 
> my application.  Is there anyway to free up memory at the end of my 
> SQLSelect?  I am doing multiple SQLSelects and the longer I work with 
> my application, the slower my PC runs as my Valentina DB is sucking up 
> my memory.
>
> Any help greatly appreciated!
> Warren
>
> On Mon, Mar 28, 2011 at 12:19 AM, Warren Kuhl <warrenkuhl at gmail.com 
> <mailto:warrenkuhl at gmail.com>> wrote:
>
>     Is there anything I have to do to a empty my memory when doing
>     select statements with Valentina?  It seems like each of my select
>     statements are increasing the storage in my memory when I run my
>     application.   Eventually the software bogs down my pc.  When I
>     comment out the select statements, this doesn't happen.  I was
>     under the impression that as long as I empty my cursor when I
>     don't need it anymore, this should take care of the problem.
>
>     Here is my code in Runtime Revolution....
>
>     put VDataBase_SqlSelect(mDatabase,"SELECT term1 FROM MyTable where
>     Keyword1 = '" & tphrase & "'") into curs
>     put  VCursor_FieldValue( curs, 1 ) into tTerms
>     put empty into curs
>
>     Thanks for any help!
>     Warren
>
>

curs is just a handle which keep reference to vCursor. In other words it 
is just a some integer (address of vCursor object)
put empty into curs  -- Just forget (loss) a handle - nothing happened 
to vCursor

Instead you should call:
put VCursor_Destructor( curs ) into curs

See V4REV examples and docs for details.

-- 
Best regards,
Ivan Smahin
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20110329/dafd07d8/attachment.htm>