vallivals

thanx 😉

this query occured 85 times opening the page

SELECT db_name_posts.* FROM db_name_posts INNER JOIN db_name_postmeta ON ( db_name_posts.ID = db_name_postmeta.post_id ) WHERE 1=1 AND db_name_posts.post_parent = 320 AND db_name_posts.post_type = 'module' AND ((db_name_posts.post_status <> 'trash' AND db_name_posts.post_status <> 'auto-draft')) AND ( db_name_postmeta.meta_key = 'module_order' ) GROUP BY db_name_posts.ID ORDER BY db_name_postmeta.meta_value+0 ASC

Don’t think I’ll post the other 3010 queries though. But most of the time goes into php processing all these, the Queries took around 6.5 sec.
then the php process time was around a minute or so.
*It is usually a bit longer actually. 😉

why am I having a hard time beliving that I’m the only one getting this issue??
this is now on 2 totally different servers =/
also each time I request that page it’s sending around 8MiB ?? .. that’s just crazy for a few lines of text..

when loading this page up, it’s using considerable amount of resources.
*note: no slow queries, (set to 1sec)

only loading “course/units” page:

(only cp pluginn running + query plugin.)
Total query time: 5.75634s for 2640 queries.
Total num_query time: 45.188 for 2643 num_queries.
and around 8.8MiB of data.

(try’d using new theme: “Twenty Fifteen”)
Total query time: 7.04740s for 2634 queries.
Total num_query time: 53.377 for 2637 num_queries.

(for fun I try’d using the “CP theme” too)
Total query time: 6.43835s for 3008 queries.
Total num_query time: 51.357 for 3011 num_queries.

for a page that lists the course units(14) +total unit subpages:(52) and its progress. thats well over 50 Queries for every subpage.. =/

specially since this is just a tiny fraction of what I had intended the amount to be.

Thank you Vinod Dalvi 😉
I’ve found that exporting/importing the course, unit, works like a charm just using the default wordpress (export/import) tool.
The real issu is the modules =/ (subpages and all the content of the courses)
and the id relations they have to the actual courses/units.

Specially as a course has gotten above average size this will become really painfull if one want’s to move this to another server even. say another version of coursepress. or from dev.server to live.server

Hey there Vinpod, And thanks for the reply.

I haven’t had the time to work on the CoursePress last 3 days now, so I don’t have much for you just yet.
But to give you an input on what I was talking about.

As for the drop and drag feature / and ability to rearrange part, was a compliment, I like it. 😉
Really simplistic and nice for smaller courses.
*might have to do some fixes for larger parts 😉 but that’s later.

It’s the Text/Editor itself when swapping to text mode(code). is what i dislike.
It wraps the html/code and adds it’s own paragraph tags, and sometimes even in random places.
*sometimes one has to Re’save the page to get the end result, because it tends to perform a double char_encoding.
And in the worst case scenario I’ve had to manually find the input through MySQL and edit it there. Since it had encoded something wrong, and did not display anything. (*think it created a comment block for some reason)
*wasn’t a problem to fix, took about 3 minutes to find out what was wrong and fix…
But the extra minutes here and there tends to pile up.

So I was going to see if I could replace the editor, but haven’t had the time so far.

Then my second subject was the performance, and I see you’ve given me a some reading material to go through and I’ll check that out, Thanks 😉

Though I was going to move the site to a clean install and do a few performance tests and see if the amount of (units + sub-page) look-ups on that page is the issue. They are quite a few.
Also, all other pages are loading fast so this shouldn’t be a cache problem

As for multisite and marketpress,
I just mentioned that my current project does not need any of that =) Just CoursePress. So I’m not worried about any of those.
*sorry about any confusion about that.

cheer’s
vallivals