Mailing List Archive

Hi Louis,

On Thu, Feb 16, 2012 at 10:29 AM, Guzik, Louis <lguzik@guttmacher.org>wrote:

> Other than accounting for currently scheduled jobs, is there any harm in
> clearing out the job table? -Any constraints or other table relationships
> that need to be taken into account?
>

Not that I know of. I know one or two users who have cleared their jobs
tables before and didn't report any issues. The Bricolage API documentation
even suggests it as a way of speeding up database performance on large
tables: http://bricolagecms.org/docs/current/api/Bric/DBA.html

Thanks,
Nick

Thanks.


On 2/16/12 11:00 AM, "Nick Legg III" <leggn@denison.edu> wrote:

>Hi Louis,
>
>On Thu, Feb 16, 2012 at 10:29 AM, Guzik, Louis
><lguzik@guttmacher.org>wrote:
>
>> Other than accounting for currently scheduled jobs, is there any harm in
>> clearing out the job table? -Any constraints or other table
>>relationships
>> that need to be taken into account?
>>
>
>Not that I know of. I know one or two users who have cleared their jobs
>tables before and didn't report any issues. The Bricolage API
>documentation
>even suggests it as a way of speeding up database performance on large
>tables: http://bricolagecms.org/docs/current/api/Bric/DBA.html
>
>Thanks,
>Nick