Re: [phpslash-users] Re: Welcome to the "phpslash-users" mailing list

[Ajay S. <ss...@od...>]

> On remor.com I was having problems with the speed of the main page
> rendering and one problem I found was that the link tables needs
> indices. They had their auto_increment fields indexed, but the
> actual link fields weren't indexed and they are used in the where
> clauses.  When you index those fields, the speed of the queries is
> unbelievably faster.  This was just something that I began to run
> into recently(i don't know why it didn't used to be slow like this).

Joe found some of the 'lut' tables that should be indexed, and that sped
up his site quite a bit.  I'm no database wizard cause I just found out
a few days ago how to use explain to... well, explain a database query.

> Just as some background info, we're coming close to having 600
> articles posted.

I've got about 600 too, Joe has like 2000!  I'd like to see how fast it
would be with 20,000 or 200,000 stories posted.

later,
ajay

--------------------------------------------------------------------
Satyajot (Ajay) Sharma
ss...@od...
Digital Odyssey System Administrator
"Intelligence is the ability to avoid doing work,
 yet getting the work done".                        --Linus Torvalds
--------------------------------------------------------------------