as code i send, only contanis two connection objects, one for odbc and other for sqlite
but i cannot see or debug it, due the interface does not show nothing ... Lenz McKAY Gerardo (PICCORO) http://qgqlochekone.blogspot.com 2017-05-25 15:31 GMT-04:00 Jussi Lahtinen <jussi.lahti...@gmail.com>: > Have you checked what the collection contains, when the system slows down? > Maybe the containing strings are longer than what you expect? Or maybe > there are more elements than you expect? > How much the running program takes memory, when things get slow? > > > Jussi > > On Thu, May 25, 2017 at 8:21 PM, PICCORO McKAY Lenz < > mckaygerh...@gmail.com> > wrote: > > > hi Jussi, the Mem are 4G , the machine are Dell vostro 210 with i7 intel > > > > well complete history its that many days before i run several times > gambas > > without close it, but in none moment used collections.. > > > > today only with project where i used collections gambas get slower after > > some hours... > > > > Lenz McKAY Gerardo (PICCORO) > > http://qgqlochekone.blogspot.com > > > > 2017-05-25 10:59 GMT-04:00 Jussi Lahtinen <jussi.lahti...@gmail.com>: > > > > > Collection requires more memory than string array, so maybe your box is > > > just swapping, because of low memory? > > > > > > > > > Jussi > > > > > > On Thu, May 25, 2017 at 6:00 AM, PICCORO McKAY Lenz < > > > mckaygerh...@gmail.com> > > > wrote: > > > > > > > there are the piece of code and here there's no secret: > > > > > > > > Public Function getItems() As Collection > > > > > > > > Dim $items As New Collection > > > > Dim itema, itemb as String = "something" > > > > > > > > $items.Add($itema, "item1") > > > > $items.Add($itemb, "item2") > > > > $items.Add(2, "cuantos") > > > > > > > > Return $items > > > > > > > > End > > > > > > > > here the previous code "bad programed" and when i swicht to > collection > > > > gambas ide get slower after some time, the code was: > > > > > > > > Public Function getItems() As String[] > > > > > > > > Dim $items As New String[] > > > > Dim itema, itemb as String = "something" > > > > > > > > $items.Add($itema) > > > > $items.Add($itemb) > > > > > > > > Return $items > > > > > > > > End > > > > > > > > the gambas ide and the OS was not shutdown during 40 days, also the > > > gambas > > > > ide was not quit in this period, and in that period i run the huge > data > > > > code of the 3 odbc bug with 100000 registers, after change the code > to > > > > collection (each change are little before test) thje ide gambas get > > slow > > > > and does not run well.. > > > > > > > > this happened to my other partners in the job... i test also in > debian > > > > jeesie and happened same! > > > > > > > > i noted that when alone user said something its like "nothigs its > > > happened, > > > > its just bad programer" > > > > > > > > will need other to reports, but these other do not have time to make > a > > > > little project and report that.. > > > > > > > > sqlite was severi broken until gambas 3.6 and must be rewrite for > > gambas > > > > 3.8 > > > > > > > > now in gamba 3.9 ther's some doc-online problems with cache and some > > > memory > > > > manage problems.. > > > > > > > > but for not specialized programmers its very difficult to debug, find > > and > > > > report LIKE THE QT problem.. > > > > > > > > > > > > > > > > Lenz McKAY Gerardo (PICCORO) > > > > http://qgqlochekone.blogspot.com > > > > > > > > 2017-05-24 17:01 GMT-04:30 Jussi Lahtinen <jussi.lahti...@gmail.com > >: > > > > > > > > > Impossible to say anything without seeing the code, which causes > the > > > > > problem. > > > > > > > > > > > > > > > Jussi > > > > > > > > > > On Thu, May 25, 2017 at 12:11 AM, PICCORO McKAY Lenz < > > > > > mckaygerh...@gmail.com > > > > > > wrote: > > > > > > > > > > > i change the odbc code for huge data to transport only two > objects > > > > with a > > > > > > string, and i noted that gambas before hangs sometimes... so i > > > > discovered > > > > > > that when i used collections the memory management are very bad.. > > > > > > > > > > > > should i send a bug or where i start to see why this happened or > > its > > > > only > > > > > > happened only to me! > > > > > > > > > > > > > > > > > > Lenz McKAY Gerardo (PICCORO) > > > > > > http://qgqlochekone.blogspot.com > > > > > > ------------------------------------------------------------ > > > > > > ------------------ > > > > > > Check out the vibrant tech community on one of the world's most > > > > > > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > > > > > > _______________________________________________ > > > > > > Gambas-user mailing list > > > > > > Gambas-user@lists.sourceforge.net > > > > > > https://lists.sourceforge.net/lists/listinfo/gambas-user > > > > > > > > > > > ------------------------------------------------------------ > > > > > ------------------ > > > > > Check out the vibrant tech community on one of the world's most > > > > > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > > > > > _______________________________________________ > > > > > Gambas-user mailing list > > > > > Gambas-user@lists.sourceforge.net > > > > > https://lists.sourceforge.net/lists/listinfo/gambas-user > > > > > > > > > ------------------------------------------------------------ > > > > ------------------ > > > > Check out the vibrant tech community on one of the world's most > > > > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > > > > _______________________________________________ > > > > Gambas-user mailing list > > > > Gambas-user@lists.sourceforge.net > > > > https://lists.sourceforge.net/lists/listinfo/gambas-user > > > > > > > ------------------------------------------------------------ > > > ------------------ > > > Check out the vibrant tech community on one of the world's most > > > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > > > _______________________________________________ > > > Gambas-user mailing list > > > Gambas-user@lists.sourceforge.net > > > https://lists.sourceforge.net/lists/listinfo/gambas-user > > > > > ------------------------------------------------------------ > > ------------------ > > Check out the vibrant tech community on one of the world's most > > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > > _______________________________________________ > > Gambas-user mailing list > > Gambas-user@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/gambas-user > > > ------------------------------------------------------------ > ------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > Gambas-user mailing list > Gambas-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/gambas-user > ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user