[campsite-support] Re: Here you go
  • Vote Up0Vote Down importimport
    Posts: 0Member
    Dear Mark,

    Please open a connection to the campsite database and run the following SQL
    statements:

    ALTER TABLE `ArticleIndex` ADD INDEX `keyword_idx`(`IdKeyword`);
    ALTER TABLE `ArticleIndex` ADD UNIQUE INDEX
    `article_keyword_idx`(`NrArticle`, `IdLanguage`, `IdKeyword`);
    ANALYZE TABLE ArticleIndex;
    ANALYZE TABLE Articles;
    ANALYZE TABLE KeywordIndex;

    This will fix your slow search issue. Campsite 3.1.2 will have this fix.

    Mugur

    On Wed, Oct 15, 2008 at 12:32 PM, Mark Corsi wrote:

    > Thanks!
    >
    >
    > Mark Corsi
    >
    >
    >
    > Thanks to TV and for the convenience of TV, you can only be one of two
    > kinds of human beings, either a liberal or a conservative.
    > - Kurt Vonnegut
    >
    >
    >
    >
  • 1 Comment sorted by
  • Vote Up0Vote Down importimport
    Posts: 0Member
    Wow! Blistering fast!

    Much, much better. Thanks!

    _____

    From: Mugur Rus [mailto:mugur.rus@gmail.com]
    Sent: Thursday, October 16, 2008 8:06 AM
    To: campsite-support@campware.org
    Subject: [campsite-support] Re: Here you go


    Dear Mark,

    Please open a connection to the campsite database and run the following SQL
    statements:

    ALTER TABLE `ArticleIndex` ADD INDEX `keyword_idx`(`IdKeyword`);
    ALTER TABLE `ArticleIndex` ADD UNIQUE INDEX
    `article_keyword_idx`(`NrArticle`, `IdLanguage`, `IdKeyword`);
    ANALYZE TABLE ArticleIndex;
    ANALYZE TABLE Articles;
    ANALYZE TABLE KeywordIndex;

    This will fix your slow search issue. Campsite 3.1.2 will have this fix.

    Mugur


    On Wed, Oct 15, 2008 at 12:32 PM, Mark Corsi wrote:


    Thanks!


    Mark Corsi



    Thanks to TV and for the convenience of TV, you can only be one of two kinds
    of human beings, either a liberal or a conservative.
    - Kurt Vonnegut
Add a Comment