I Can't Believe the Difference in Speed

[amykhar]

It makes queries to the post table faster because the index orders the posts. So, queries that look for posts since a given date are significantly sped up.

[Boofo]

Today at 03:04 PM amykhar said this in Post #11
It makes queries to the post table faster because the index orders the posts. So, queries that look for posts since a given date are significantly sped up.

Does it do it retroactively or just with posts made after adding the query?

[Xenon]

an DB index is for all data in the table, not just for the new ones

btw. to speed up the getnew post you can add also an index to thread.lastpost

it reduced the gen time on vb.org from .27 to .07

[Erwin]

Good tips.

[Boofo]

Any other places where an index might help speed things up?

[Dolby]

Any drawbacks to doing this? Can it be un-done?

[Xenon]

@boofo: currently i don't know any others, but i'm sure there can be some.
but it's also depending on your hacks and so on, where you could need an index

@Dolby: well each index requires DB Space
you can see on the tablestatistics how much space the data takes and how much the indexes take.
yes it can be un-done

[Erwin]

FWIW, I added indexes to post.dateline, thread.lastpost as well as thread.lastposter - did speed things up at my site.

[Boofo]

Today at 06:26 AM Erwin said this in Post #18
FWIW, I added indexes to post.dateline, thread.lastpost as well as thread.lastposter - did speed things up at my site.

How much overhead does each index add to the db? Just curious.

[cinq]

Is there any downsides to doing this ?

Also what should i do to implement this ?
Basic instructions would be appreciated ( nooB here )