Database Version: 191 My current connection string... "jdbc:h2:../../data/audit/msgfwd;COMPRESS=TRUE;AUTOCOMMIT=FALSE;lock_timeout=60000;MVCC=FALSE;DB_CLOSE_ON_EXIT=TRUE;MV_STORE=TRUE;LOB_TIMEOUT=10000;AUTO_SERVER=TRUE;AUTO_SERVER_PORT=%port%"
Database file is growing... can't keep up. ( 10 GB now ) Have multiple producers and multiple consumers. Each producer will place a small file ( CLOB ) in the database for each of the producers to stream down. The consumers are getting a records so slowing the database is growing. consumers query for a list of primary keys once a second with a limit of 300; When the get the pk list they begin to stream the clobs local in a loop. Then repeat the process. I current have MVCC turned off because Thomas did not think it was ready. I have also seen comments from Noel suggestion someone switch back from MV_STORE to possibly improve speed. Two Questions.. 1. is MVCC ready for prime time with MV_STORE? 2. Is it possible to turn MV_STORE off at this point without lossing data ( database approx 10+GB ) - would that help? Thanks. -- 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 https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
