Search found 8 matches

by tornado_mtb
Sun Jul 15, 2012 3:24 am
Forum: [3.x] Discussion
Topic: Why PHP take more CPU time than MySQL ?
Replies: 18
Views: 16720

Re: Why PHP take more CPU time than MySQL ?

Good example, Thanks.
by tornado_mtb
Sat Jul 14, 2012 2:42 pm
Forum: [3.x] Discussion
Topic: Why PHP take more CPU time than MySQL ?
Replies: 18
Views: 16720

Re: Why PHP take more CPU time than MySQL ?

nademan, Is it significant faster? I concern downtime. I use yum update and it not automatic on this upgrade. I donot have experince upgrade php by manual before,
by tornado_mtb
Sat Jul 14, 2012 5:38 am
Forum: [3.x] Discussion
Topic: Why PHP take more CPU time than MySQL ?
Replies: 18
Views: 16720

Re: Why PHP take more CPU time than MySQL ?

I use PHP Version 5.3.8 , Is 5.4 faster than 5.3? I concern more speed than memory.
by tornado_mtb
Fri Jul 13, 2012 8:30 pm
Forum: [3.x] Discussion
Topic: Why PHP take more CPU time than MySQL ?
Replies: 18
Views: 16720

Re: Why PHP take more CPU time than MySQL ?

More RAM helps assuming you use it. Faster CPU would make the php code execute faster. What sort of site are you running? Meaning how many concurrent users do you have? My server regularly supports hundreds of concurrent users without problems, and I've seen over a thousand concurrent users during ...
by tornado_mtb
Thu Jul 12, 2012 5:26 pm
Forum: [3.x] Discussion
Topic: Why PHP take more CPU time than MySQL ?
Replies: 18
Views: 16720

Re: Why PHP take more CPU time than MySQL ?

Thanks so much drathbun , I don't have much experince on php , but as you said ,it look very interesting and hard work to deef tune back to phpbb2. I can not do like this since my board have to maintain many visitor. What I do is install APC. it help a little on loading time (like from 0.5 to 0.4 , ...
by tornado_mtb
Thu Jul 12, 2012 5:50 am
Forum: [3.x] Discussion
Topic: Why PHP take more CPU time than MySQL ?
Replies: 18
Views: 16720

Re: Why PHP take more CPU time than MySQL ?

Code: Select all

Page generated in 0.5483 seconds with 11 queries + 3 queries returning data from cache

Time spent on mysql4 queries: 0.06222s | Time spent on PHP: 0.48605s
I try to turn off gzip, but PHP still much than mysql.
by tornado_mtb
Wed Jul 11, 2012 7:04 pm
Forum: [3.x] Discussion
Topic: Why PHP take more CPU time than MySQL ?
Replies: 18
Views: 16720

Why PHP take more CPU time than MySQL ?

In my debug message below board show that. [ Time : 0.429s | 16 Queries | GZIP : On | Load : 0.58 | Memory Usage: 5.47 MiB | Explain ] Then I click "explain" SQL Report Page generated in 0.4241 seconds with 11 queries + 3 queries returning data from cache Time spent on mysql4 queries: 0.04604s | Tim...
by tornado_mtb
Mon Feb 01, 2010 4:29 pm
Forum: [3.0/Olympus] Discussion
Topic: Optimizing viewtopic query
Replies: 4
Views: 5842

Re: Optimizing viewtopic query

Thanks! I add your comment about session to using btree. result is good.

but for the my_index , if user don't use sort by "topic_last_post_time", what is happen?
and which source file do you modify put force to?