Bill,
There isn't an option but you can directly set it with
tdbloader -loc DB ...
rm -f DB/stats.opt
touch DB/none.opt
fixed.opt is also another optimizer option. Just change to "touch
DB/fixed.opt".
If it's creating one even on an incremental add of data, then that's a
bug - could you file a JIRA about it please? Such a stats.opt file is
probably wrong, either useless of maybe even a cause of poor optimization.
The fact that optimizer is unoptimizing is worth investigating. Can you
send me the data and a query that illustrates the effect?
Andy
On 18/08/11 10:54, Bill Roberts wrote:
Is there an option for tdbloader to ask it not to create the stats.opt file?
I am still finding that I get the best overall performance from TDB with no
optimisation (perhaps because I am not smart enough to create a well-tuned
optimisation file, despite Andy's useful advice!). But if I use tdbloader to
add new data to a store, then tdbloader (0.8.10) creates a new stats.opt file,
which I then have to remove again.
Thanks
Bill
