Delete ofbiz Timestamp Indices?

[Steve Fatula]

I believe these might be used for sync between instances. So, let's  
say you have no interest in ever doing so.

Is there any harm to deleting all of the timestamp indices in all of  
the tables, in order to gain some measure of performance back? Are  
they used for anything else other than syncing which would make this a  
very bad idea?

Steve

[Jacques Le Roux]

Audit at least...

Jacques

From: "Steve" <[hidden email]>

>I believe these might be used for sync between instances. So, let's  
> say you have no interest in ever doing so.
>
> Is there any harm to deleting all of the timestamp indices in all of  
> the tables, in order to gain some measure of performance back? Are  
> they used for anything else other than syncing which would make this a  
> very bad idea?
>
> Steve
>

[David E. Jones-2]

Removing the indexes would just have an effect on query performance,  
so if you're not querying much it wouldn't matter (and would make  
writes faster). You can also add indexes back at any time to get the  
query performance benefit. Other things in the system may query by  
those columns, but unless you notice a slow down then you're good to  
go...

-David


On Oct 9, 2009, at 11:56 AM, Steve wrote:

> I believe these might be used for sync between instances. So, let's  
> say you have no interest in ever doing so.
>
> Is there any harm to deleting all of the timestamp indices in all of  
> the tables, in order to gain some measure of performance back? Are  
> they used for anything else other than syncing which would make this  
> a very bad idea?
>
> Steve