Forums / Cotonti / General / Question about table indexes

performance

ez
#22838 2010-02-11 21:29
Hi,

Can anyone tell me why in the pages table the page_begin and page_expire are not indexed ?

For example the newsplugin uses these fields in the select statements, so maybe it is better to have them indexed ? Also page_ownerid wich is used to look up avatars.

I hope that anybody can tell me.
I want to improve the speed (It is allready fast, but there is room for improvement)

greetz,

Leo (ez)
==- I say: Keep it EZ -==