Mailing List Archive: Bricolage: users

job table question

Index | Next | Previous | View Threaded

lguzik at guttmacher

Feb 16, 2012, 7:29 AM

Post #1 of 3 (557 views)
Permalink

job table question

Hi.

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?

-Thanks.

leggn at denison

Feb 16, 2012, 8:00 AM

Post #2 of 3 (534 views)
Permalink

Re: job table question [In reply to]

Hi Louis,

On Thu, Feb 16, 2012 at 10:29 AM, Guzik, Louis <lguzik [at] guttmacher>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

lguzik at guttmacher

Feb 16, 2012, 8:11 AM

Post #3 of 3 (533 views)
Permalink

Re: job table question [In reply to]

Thanks.

On 2/16/12 11:00 AM, "Nick Legg III" <leggn [at] denison> wrote:

>Hi Louis,
>
>On Thu, Feb 16, 2012 at 10:29 AM, Guzik, Louis
><lguzik [at] guttmacher>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

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads