We are using the embedded database, and to this point everything has been alright, but our conversation log is some 750MB’‘s and it’'s almost impossible to search through archives now.
Is there any way to reset this? I don’‘t care about saving the data, and I realize that if we’‘d be using MySQL in the first place, this would be a piece of cake, but we don’'t
I’'ve searched everywhere for the last few hours and the only way I could see this remotely doable would be to connect to the hsqldb directly via java -cp, but all the SQL query tools I see require X11.
Any advice would be appreciated.