Any way to delete features and feature categories from database?

[Jonathon -- Improov <jo...@improov.com>]

Getting bloated.

Jonathon

Re: Any way to delete features and feature categories from database?

[Jacques Le Roux <ja...@les7arts.com>]

SQL...

Jacques

----- Original Message ----- 
From: "Jonathon -- Improov" <jo...@improov.com>
To: <of...@incubator.apache.org>
Sent: Thursday, January 11, 2007 12:55 PM
Subject: Any way to delete features and feature categories from database?


> Getting bloated.
> 
> Jonathon

RE: Any way to delete features and feature categories from database?

[Andrew Ballantine <ac...@willowbrook.co.uk>]

Jonathon

As a general principle a business should not delete operational data which
includes which features and categories that were available at a particular
time. One should always endeavour to keep an accurate record of a business
as one always needs to guard against litigation. However this does mean that
you have to maintain a huge database although size should not affect
performance much if designed well.

If you are desperate to reduce the size of the database you could transfer
all your current data, features and categories to a new version of the
database and transfer to that as your live database and save for old
database for historical records. You should remember that most countries
require that records are kept for a minimum amount of time and this includes
computer records.

I do not know how easy this is to do in OFBiz, but that would be the general
principle I would recommend.

My question would be why do you feel your database is bloated?
If you have redundant features, can you not turn them off by defining the
end-date. I remember that product pricing can be date controlled, so I
assume the same might apply to features and categories. If not then that is
perhaps a feature that should be requested.

Hope this is of some help.

Kind regards,

Andrew Ballantine.
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.16.9/622 - Release Date: 10/01/2007
14:52



*****************************************************************
This email has been checked by the altohiway Mailcontroller Service
*****************************************************************