Re: [Fofredux-devel] Reduce cpu usage?

[Miles B. <mil...@gm...>]

I do have access to phpmysladmin. I did an optimization and here are
the differences.

The total table size went from 14.5 MiB to 13.2 MiB.
The overhead went from 736.3 KiB to 0 KiB.

-Miles

On 1/31/07, Evan Roth <eva...@gm...> wrote:
> if you have phpmysqladmin access to your database, try to optimize all of
> the tables.  with 48 feeds, i could imagine that the items table could be
> quite fragmented, if you are not reading often and deleting stuff as it gets
> added.  perhaps your provider would let you see the SQL that is taking so long on
> the server, to allow us to optimize.  we could also take a deeper look at
> the db itself...perhaps we should add some indexing somewhere or something.
> or at least it tells us exactly what is causing the problem.