Hello - I recently used csvread to load just north of 35 million rows into an H2 table that had a couple indices and several times found myself wondering "what's going on in there?" To make the process even more fun I had a timestamp conversion going on one of the fields. Total database size came out to about 95 gigs.
I kicked off the process on a Friday night and decided on Sunday morning that it must be stuck and killed the java process. On restarting I found that all the rows had been loaded so I found myself wondering what the process had been up to for all that time? Rebuilding the indices? Does that mean my indices are incomplete since I killed the process? For what it's worth I'm able to query the database just fine (queries are nice and fast on indexed columns). My questions would be: 1. Is there a way to make csvread log the # of rows loaded the way Sybase's bcp or Oracle's sqlldr do? 2. If the engine is using CPU time doing "something" and you want to know what, is there a way to get a listing of the processes going on? Like Sybase's sp_who? Thanks, Henry -- 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.
