Fancy a spot of user testing?

[RFH Reseller: nick]

Hi there people.

Just thought I'd post a link to a site I've just 'deployed' for a client, basically it's a, can you spot any glaring problems, request... Always nice to get as many critical pairs of eyes as possible. This includes any usability issues you may have.

http://www.stickitonawall.com/

cheers

[RFH Customer: Reactivate]

This page is not Valid XHTML 1.1!


well so the link at the bottom says anyway

[RFH Reseller: nick]

This page is not Valid XHTML 1.1!


well so the link at the bottom says anyway

Good spot, empty class attributes. I'll get that fixed then
____
EDIT
Fixed.

[Staff: Warren Ashcroft]

What does it use? The wall pages seem slow, but contact us pages etc... are fine.

Also - how big will this site get? Are you aiming for something like Million Dollar Homepage? Reason I ask is that got alot of DDoS attacks back in the day.

[RFH Reseller: nick]

What does it use? The wall pages seem slow, but contact us pages etc... are fine.

Also - how big will this site get? Are you aiming for something like Million Dollar Homepage? Reason I ask is that got alot of DDoS attacks back in the day.

Actually, yes I had spotted the slowness you are talking about, I pretty much know where it's coming from. So I should get that fixed. The total time should be around .2 seconds, which it actually was until last week when the client wanted something changed at last minute. I note now it has shot up to about .6 seconds, and I have a fair idea of why. Should be able to get it up to speed again.


As for how big the site will get, well... it's not my site, but I expect they would like it to become very big. If it looks like it is going that way I will not host it on a shared server. Milliondollar pixel site did get some serious DDoS problems, a victim of it's own success. I don't really have an answer to that beyond my previous sentence.

[Staff: Warren Ashcroft]

No probs, be interesting to know what caused the slowness

[Staff: Warren Ashcroft]

Speaking of Million Dollar Homepage - that kid is now a millionaire, not bad for a TINY amount of web skill and a great idea

[RFH Reseller: nick]

No probs, be interesting to know what caused the slowness

Am fairly sure it is MySQL (something that would lend itself very much to the stored procedure I might add, hint hint).

[Staff: Warren Ashcroft]

Am fairly sure it is MySQL (something that would lend itself very much to the stored procedure I might add, hint hint).

I hear ya

[RFH Reseller: nick]

If you are interested, these look like the culprits. In fact, it's always just the first on executed - if they are both run, the second one is fast, maybe MySQL builds some sort of temporary index? I don't know.


I'll have to sit and think about it for a bit, SQL is not my strong point, so if anyone feels they can put me to shame with some clever coding, feel free

They basically select the posters that appear, depending upon keyword relationships. The keywords are in a nested sets though, so posters need to be retrieved that are related to any offspring of the chosen keyword, as well as the keyword itself.



The first query just totals the number of results, and the second fetches the data, returning only a limited random selection.

SELECT
    COUNT(*) as total
FROM
    keywords_map 
WHERE
    keywords_map.keyword_id IN
    (
    SELECT 
        node.id
    FROM 
        keywords AS node,
        keywords AS parent
    WHERE 
        node.lft 
        BETWEEN 
            parent.lft 
            AND 
            parent.rgt
 
        AND  (
        keywords_map.keyword_id
        IN
        (
        SELECT 
            node.id
        FROM 
            keywords AS node,
            keywords AS parent
        WHERE 
            node.lft 
            BETWEEN 
                parent.lft 
                AND 
                parent.rgt
            AND 
            parent.id IN (91)
        )
        )
    )

SELECT DISTINCT
        ads.[...]
    FROM 
        ads
    WHERE
        ads.id
        IN
        (
        SELECT
            ads.id
        FROM
            wall_keywords_map 
            INNER JOIN 
                ads 
                ON 
                wall_keywords_map.advert_id = ads.id
        WHERE
            wall_keywords_map.keyword_id 
            IN
            (
                SELECT 
                    node.id
                FROM 
                    wall_keywords AS node,
                    wall_keywords AS parent
                WHERE 
                    node.lft 
                    BETWEEN 
                        parent.lft 
                        AND 
                        parent.rgt 
                    AND  (
        ads.id
        IN
        (
        SELECT
            ads.id
        FROM
            wall_keywords_map 
            INNER JOIN 
                ads 
                ON 
                wall_keywords_map.advert_id = ads.id
        WHERE
            wall_keywords_map.keyword_id 
            IN
            (
                SELECT 
                    node.id
                FROM 
                    wall_keywords AS node,
                    wall_keywords AS parent
                WHERE 
                    node.lft 
                    BETWEEN 
                        parent.lft 
                        AND 
                        parent.rgt
                    AND 
                    parent.id IN (91)
            )
        )
        )
            )
        )
    ORDER BY RAND();