manifoldcf-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Karl Wright <>
Subject Re: is huge
Date Wed, 20 May 2015 01:35:49 GMT
FWIW, if you want to "reset", just delete the hsqldb database files and
start over.  This happens when you "ant clean" as well.


On Tue, May 19, 2015 at 9:34 PM, Karl Wright <> wrote:

> Hi Deanna,
> HSQLDB is not great for production use for a number of reasons; it's also
> unconstrained in memory consumption.
> Indexing 30 rows over and over should not create a huge table; I suspect
> that if you queried it you would find the number of rows to be tiny. The
> reason it gets big has to do mainly with HSQLDB disk management algorithms
> not being that great.  So try MySQL or PostgreSQL is my suggestion.
> Karl
> On Tue, May 19, 2015 at 6:10 PM, Delapasse, Deanna <
>> wrote:
>> Sorry for all these emails!  One more really easy question and I promise
>> to stop bothering y'all for a while.
>> While running locally on my laptop using the simple example my
>> file (I guess this is my hsqldb) get huge!!!  I'm only indexing
>> 30 rows over and over (working on some connector enhancements and learning
>> Elastic Search), but my is already > 11GB.
>> I don't need to keep any of this data.  Is there a fast, easy way to just
>> 'reset' my db? I don't mind recreating my output/repo/jobs?
>> I'm in a meeting right now listening to my boss tell some bigwigs how
>> we're got this all figured out (which explains all my stress-filled emails)
>>  :-).
>> Thanks!!!
>> Deanna

View raw message