Hi guys.. I am new in H2DB .i m running system where H2db is having around 3 crore [30 million] data in one table only. [H2DB contains 1 table only]
select query normally takes milliseconds only.around 100-200 ms. bt at sudden h2db takes upto 90 second for a single fetch query. this happens for 1 particular second.after that again all are fine. in a day this happens for 10 times. :-( Please let me know any solution for this situation. because performance accepted is upto 20 ms for single select query. URLL CONNECTION is jdbc:h2:/data/Testbed/h2DB/Arun;DB_CLOSE_ON_EXIT=FALSE;FILE_LOCK=NO;LOG=2 and jar version is h2-1.1.114.jar. select query is running by 20 threads and 150 selecion per second. -- 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.
