queries and MEMORY LEAKS

  1. 7 months ago
    Edited 7 months ago

    hi, I've seen that every query eats up a bit of ram, until you run out of available one and block the system

    in this specific case i tried to make a new web app, connect to a sql server with session.dbA property in the open event of the session, then i created a webpage button ButtonA in which i use a rowset rA to make a query and then i close this rowset
    every time i press the button the app consumes a bit of ram.

    session.DBA as MSSQLServerDatabase

    session.DBA as new MSSQLServerDatabase
    session.open end

    dim rA as Rowset
    rA=Session.dbA.SqlSelect("select a,b,c from tblA")
    ButtonA.action end

    every time I press the ButtonA, the app eats a bit of ram, even if I close the connection to the db at session level.

  2. Julian S

    30 Nov 2019 Xojo Pro UK
    Edited 7 months ago

    What version of xojo are you using, I found and reported lots of database related leaks recently and they are being/have been fixed already in the latest release.

  3. rel. 2.1 fixed this problem

or Sign Up to reply!