Unoptimized query

[cobaku]

i was already using your suggested solution, but i feel like i have to eliminate the problem completely.
thanks for your amazing detailed reply. I will definitely try sphinx.
i am using query caching and will also search what normalization on the linux timestampis

i am currently stuck at configuring
what i am trying to optimize is this

PHP Code:

    $threadscount = $db->query_first_slave("
        SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > $lastread AND open <> 10, 1, 0)) AS newthread
        $hook_query_fields
        FROM " . TABLE_PREFIX . "thread AS thread
        $tachyjoin
        $hook_query_joins
        WHERE forumid = $foruminfo[forumid]
            AND sticky = 0
            $prefix_filter
            $visiblethreads
            $globalignore
            $limitothers
            $datecut
            $hook_query_where
    "); 


what i have to configure is
at /etc/sphinx/sphinx.conf
below

PHP Code:

source src1
{
        type                                    = mysql

        sql_host                                = localhost
        sql_user                                = test
        sql_pass                                =
        sql_db                                  = test
        sql_port                                = 3306  # optional, default is 3306

        sql_query                               = \
                SELECT id, group_id, UNIX_TIMESTAMP(date_added) AS date_added, title, content \
                FROM documents

        sql_attr_uint                   = group_id
        sql_attr_timestamp              = date_added

        sql_query_info                  = SELECT * FROM documents WHERE id=$id
} 


i found an example at https://vborg.vbsupport.ru/attachmen...8&d=1210237129 i hope it works

--------------- Added [DATE]1254179115[/DATE] at [TIME]1254179115[/TIME] ---------------

ok it seems this config thing is much bigger than i can ever understand

was worth to try

but i may still implement search sphinx