https://www.cotonti.com Last topic posts Cotonti en Sat, 18 Apr 2026 00:31:16 -0000 Clients... Yes, i will be carefull with that

I need to do testing, but some things I know in advance...

Like page_state index is not good... (Thats a fact)
Indexes only work if there is a lot off different data... page_state is 0 or 1 so this is not worth indexing.

This is base knowledge indexing

greetz]]> Fri, 12 Feb 2010 20:25:40 -0000 ]]> Fri, 12 Feb 2010 20:19:04 -0000 Like I said.. I know some ground rules about optimizing sql, but you are right we need more research..

If anybody can help, please let us know..]]> Fri, 12 Feb 2010 16:49:56 -0000 Fri, 12 Feb 2010 14:11:18 -0000
I know this already... I have done some SQL optimizing myself (NOT MySql).

But I was wondering howto best tweak database performance (MySQL)

And pages are used a lot, so this is a good place to look

But it is hard when loading times vary so much.. (I am looking on a website on a shared server)


page3 is interesting!!

http://www.databasejournal.com/features/mysql/article.php/10897_1382791_3/Optimizing-MySQL-Queries-and-Indexes.htm]]> Fri, 12 Feb 2010 04:37:26 -0000 Fri, 12 Feb 2010 04:05:33 -0000
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)]]> Thu, 11 Feb 2010 21:29:10 -0000