queries and MEMORY LEAKS

  1. last week

    Jury B

    Nov 30 Pre-Release Testers
    Edited last week

    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.open
    session.DBA as new MSSQLServerDatabase
    Session.dbA.DatabaseName="dbXX"
    Session.dbA.Host="ipXX"
    Session.dbA.UserName="xxAD"
    Session.dbA.Password="xxPW"
    Session.dbA.TimeOut=60
    session.open end

    ButtonA.Action
    dim rA as Rowset
    rA=Session.dbA.SqlSelect("select a,b,c from tblA")
    ra.close
    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

    Nov 30 Pre-Release Testers, Xojo Pro UK
    Edited last week

    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. Jury B

    Dec 2 Pre-Release Testers

    rel. 2.1 fixed this problem

or Sign Up to reply!