Site running slow

[clairec]

Hi there,

I'm developing a website with Typolight and it's pretty big.

I had problems with my hosting company's mySql server when I began developing this site and it always ran painfully slow.

Now this issue is meant to be resolved
I have other sites on that same hosting with php and mysql and they seem to be better but my typolight site is still taking about 4 -5 seconds to load each page, each time it's clicked!
I turned on debug to see would that shed some light but I have to be honest I'm not sure what the messages mean,

A typical pages gives me between 200 and 400 of these messages:

Code: Select all

Array
(
    [0] => Array
        (
            [0] => SELECT * FROM tl_page WHERE (id='35' OR alias='35') AND (start='' OR start<1266232068) AND (stop='' OR stop>1266232068) AND published=1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [type] => index_merge
                    [possible_keys] => PRIMARY,alias
                    [key] => PRIMARY,alias
                    [key_len] => 4,130
                    [ref] =>
                    [rows] => 2
                    [Extra] => Using union(PRIMARY,alias); Using where
                )

        )


which doesn't seem right to me,
and also in my System log it says it's "Running daily cron jobs"
as far as I know I don't have any jobs set up,
Is this harmless or could it be slowing it too?

Now I know I need to give more information about the wesbite and hosting but as the client is confidential I can't post a link.
I am just wondering what things can I check for before I have to resort to that?

Thanks in advance

Note: It's typolight 2.7.1

[Ben]

Clairec,

Did you ever get things running faster? My experience with TYPOlight is this: when it's running slow, the server is bogged down and/or has too many sites. If possible, try it on a different server.

The cron jobs that you see in the log are just automated, daily routines such as re-creating css, xml files and I think re-building the search engine. They only occur at certain intervals though (daily, weekly, etc.)

[acenes]

When the file system/localconfig.php is not writable by php, the cron job will not be able to store its current state.
That will cause the cron to run at every single page load, what might be happening in your case.

Upload and run the system check tool to identify the source of the problem:

http://www.typolight.org/configuring-th ... check-tool

[clairec]

Hi guys,

thanks for the replies

I updated to the latest typolight and turned on caching and that has helped a lot.

It's shared hosting I'm on which I knew would be a part of the problem but I will try the system check tool too

[Ben]

Clairec,

It's a shot in the dark, but if you're on the mediatemple gridserver, you can expect page loads to take between 5 and 30 seconds.

[Medianomaly]

I am on a MediaTemple Gridserver (not for long..) and I can attest to that as well.

Especially lately, load times have been excruciating.