Delete ofbiz Timestamp Indices?

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

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
Reply | Threaded
Open this post in threaded view
|

Re: Delete ofbiz Timestamp Indices?

Jacques Le Roux
Administrator
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
>

Reply | Threaded
Open this post in threaded view
|

Re: Delete ofbiz Timestamp Indices?

David E. Jones-2
In reply to this post by Steve Fatula

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