Computer program for client usage. Program start connect to db Program end disconect from db Average run time 24h+
during testing no inserts were made only selects. Select GPS data - no records gps device was not connected Select unsend program status (user imput - no records) using left join from 2 tables. But as mentioned before result always was 0, becouse user was doing no interaction in program. how much memory it consumed hard to tell. In total use was 1.8 GB heap, program start stable was 250 mb. After all components and used data was prepared. I don't say difference is used size, might be other services at fault too, but yesterday tryed SQLite with same parameters Heap still increases but in slower paste and is about 1.3 GB of ram use in 19h of program run. Java still runs so far, while with h2 implementation 1.8 GB was reached in less than 9 and finally java crashed couse out of memory. To be more precise implementation i use of both h2 and SQLite are identical same selects etc. Only difference is sequences, SQLite dont have them so had to change a bit code in there with commit rollback and return record id instead. But as mentioned above no Gps device and no user input was made in both cases, so database should be with no or couple records during entire program run. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
