AW: INET doesn't free memory

> Sood_Niraj/SO@instru.fi schrieb im Beitrag <53dc4j$551@cssun.mathcs.emory.edu>... > > --openmail-part-00194279-00000002 > Content-Type: text/plain; charset=US-ASCII; name="INET" > Content-Transfer-Encoding: quoted-printable > > Hi, = > > > We problem with INET (current version 5.01.WJ2). It appears that the dll= > > file ISQLI501.dll is using more and more memory (starting from 293 kb) > in every second SQL-statement. So in the end windows (3.11) runs out of > memory and pc-has to be rebooted. Usually if user closes the application= > We had the same problem with previous versions of I-Net and ODBC and found out that 2 different SQL commands triggers memory consumption. The first one was using of SQLExecDirect instead of SQLPrepares and then reusing via SQLExecute. This is solvable via changing your application. The second problem was using mass inserts. I haven't tested the version 5.01.WJ2 relating to this point because we changed the application accordingly and since then we had no problems with it. -- Bye, Thomas Muth > the ISQLI501.dll-process dies OK, but sometimes it doesn't. In my > opinion this is a BUG. What should we do? Are aware of this problem? = > > > thanks, > Niraj Sood > Instru Data > > niraj.sood@instru.fi > > > --openmail-part-00194279-00000002 > Content-Type: application/rtf; name="INET" > Content-Transfer-Encoding: base64 > > {\\rtf1\\ansi\\deff0{\\fonttbl{\\f0\\froman Tms Rmn;}{\\f1\\froman Courier New;}}{\\colortbl\\red0\\green0\\blue0;\\red0\\green0\\blue255;\\red0\\green255\\blue255;\\red0\\green255\\blue0;\\red255\\green0\\blue255;\\red255\\green0\\blue0;\\red255\\green255\\blue0;\\red255\\green255\\blue255;\\red0\\green0\\blue127;\\red0\\green127\\blue127;\\red0\\green127\\blue0;\\red127\\green0\\blue127;\\red127\\green0\\blue0;\\red127\\green127\\blue0;\\red127\\green127\\blue127;\\red192\\green192\\blue192}{\\info{\\creatim\\yr1996\\mo10\\dy8\\hr13\\min3\\sec25}{\\version1}{\\vern197985}}\\paperw12240\\paperh15840\\margl720\\margr2836\\margt1440\\margb1440\\deftab720\\pard\\ql\\li0\\fi0\\ri28{\\f1\\fs20\\cf0\\up0\\dn0 Hi, }{\\par}\\pard\\ql\\li0\\fi0\\ri28{\\f1\\fs20\\cf0\\up0\\dn0\\par}\\pard\\ql\\li0\\fi0\\ri28{\\f1\\fs20\\cf0\\up0\\dn0 We problem with INET (current version 5.01.WJ2). It appears that the dll }\\ql{\\f1\\fs20\\cf0\\up0\\dn0 file ISQLI501.dll is using more and more memory (starting from 293 kb) }\\ql{\\f1\\fs20\\cf0\\up0\\dn0 in every second SQL-statement. So in the end windows (3.11) runs out of }\\ql{\\f1\\fs20\\cf0\\up0\\dn0 memory and pc-has to be rebooted. Usually if user closes the application }\\ql{\\f1\\fs20\\cf0\\up0\\dn0 the ISQLI501.dll-process dies OK, but sometimes it doesn't. In my }\\ql{\\f1\\fs20\\cf0\\up0\\dn0 opinion this is a BUG. What should we do? Are aware of this problem? }{\\par}\\pard\\ql\\li0\\fi0\\ri28{\\f1\\fs20\\cf0\\up0\\dn0\\par}\\pard\\ql\\li0\\fi0\\ri28{\\f1\\fs20\\cf0\\up0\\dn0 thanks,}{\\par}\\pard\\ql\\li0\\fi0\\ri28{\\f1\\fs20\\cf0\\up0\\dn0 Niraj Sood}{\\par}\\pard\\ql\\li0\\fi0\\ri28{\\f1\\fs20\\cf0\\up0\\dn0 Instru Data}{\\par}\\pard\\ql\\li0\\fi0\\ri28{\\f1\\fs20\\cf0\\up0\\dn0\\par}\\pard\\ql\\li0\\fi0\\ri28{\\f1\\fs20\\cf0\\up0\\dn0 niraj.sood@instru.fi}{\\par}\\pard\\ql\\li0\\fi0\\ri28} > > --openmail-part-00194279-00000002-- > >