NooTheme Premium WordPress Theme › Forums › Timetable › Website loads very slow
Tagged: mysql, performance, slow
- This topic has 3 replies, 2 voices, and was last updated 2 years, 5 months ago by Jackie.
-
AuthorPosts
-
2 years, 5 months ago #1218487
I have the a performance problem, Slow web site only when activating NOO Timetable: 17 seconds to load the home page, who's MySQL queries take more than 8 seconds !!!!:
0.000000 sendto(3, "'\1\0\0\3\n\t\t\tSELECT DISTINCT t.term_"..., 299, MSG_DONTWAIT, NULL, 0) = 299 0.000267 poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 86400000) = 1 ([{fd=3, revents=POLLIN}]) 0.000641 recvfrom(3, "\1\0\0\1\1\\\0\0\2\3def/ritmoytumbao_wp0d3"..., 32768, MSG_DONTWAIT, NULL, NULL) = 119 0.597599 sendto(3, "'\1\0\0\3\n\t\t\tSELECT DISTINCT t.term_"..., 299, MSG_DONTWAIT, NULL, 0) = 299 0.000175 poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 86400000) = 1 ([{fd=3, revents=POLLIN}]) 0.000760 recvfrom(3, "\1\0\0\1\1\\\0\0\2\3def/ritmoytumbao_wp0d3"..., 32768, MSG_DONTWAIT, NULL, NULL) = 126 0.595207 sendto(3, "'\1\0\0\3\n\t\t\tSELECT DISTINCT t.term_"..., 299, MSG_DONTWAIT, NULL, 0) = 299 0.000131 poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 86400000) = 1 ([{fd=3, revents=POLLIN}]) 0.000659 recvfrom(3, "\1\0\0\1\1\\\0\0\2\3def/ritmoytumbao_wp0d3"..., 32768, MSG_DONTWAIT, NULL, NULL) = 125 0.644994 sendto(3, "'\1\0\0\3\n\t\t\tSELECT DISTINCT t.term_"..., 299, MSG_DONTWAIT, NULL, 0) = 299 0.000150 poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 86400000) = 1 ([{fd=3, revents=POLLIN}]) 0.000636 recvfrom(3, "\1\0\0\1\1\\\0\0\2\3def/ritmoytumbao_wp0d3"..., 32768, MSG_DONTWAIT, NULL, NULL) = 125 0.605540 sendto(3, "\262\0\0\0\3\n\t\t\tSELECT t.term_id\n\t\t\tFR"..., 182, MSG_DONTWAIT, NULL, 0) = 182 0.000165 poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 86400000) = 1 ([{fd=3, revents=POLLIN}]) 0.000705 recvfrom(3, "\1\0\0\1\1\\\0\0\2\3def/ritmoytumbao_wp0d3"..., 32768, MSG_DONTWAIT, NULL, NULL) = 180 0.000247 sendto(3, "{\0\0\0\3SELECT t.*, tt.* FROM wp_te"..., 127, MSG_DONTWAIT, NULL, 0) = 127 0.000055 poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 86400000) = 1 ([{fd=3, revents=POLLIN}]) 0.000236 recvfrom(3, "\1\0\0\1\n\\\0\0\2\3def/ritmoytumbao_wp0d3"..., 32768, MSG_DONTWAIT, NULL, NULL) = 1164 0.001091 sendto(3, "\311\0\0\0\3\n\t\t\tSELECT wp_posts.*\n\t\t\t"..., 205, MSG_DONTWAIT, NULL, 0) = 205 0.000062 poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 86400000) = 1 ([{fd=3, revents=POLLIN}]) 0.000379 recvfrom(3, "\1\0\0\1\27Y\0\0\2\3def/ritmoytumbao_wp0d3"..., 32768, MSG_DONTWAIT, NULL, NULL) = 4301 7.437586 mmap(NULL, 2097152, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x73c617e00000 0.000302 munmap(0x73c617e00000, 2097152) = 0 0.000317 mmap(NULL, 2097152, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x73c617e00000 0.000114 munmap(0x73c617e00000, 2097152) = 0 0.000387 mmap(NULL, 2097152, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x73c617e00000 0.000162 munmap(0x73c617e00000, 2097152) = 0
Attachments:
You must be logged in to view attached files.2 years, 5 months ago #1218491Hello.
Thank you for contacting us.
Yes, maybe you have many classes or use the number week to repeat the class. That will increase the time loading for the schedule. Please give us your site URL, and admin account. We will help you check it.
Thanks.
2 years, 5 months ago #1218506Hi, the number of weeks could be then the origin (not too much clases)? OK, I have changed to 104 weeks and you are right. Now the web site is normal.
What number should I put to indicate the class have no finish end ?
2 years, 5 months ago #1218514Hi.
Please do not input a large number for the week repeat. For the schedule, it will calculate all the weeks to render the data to display on the schedule. That is why your site will run slowly.
To avoid that issue, please go to edit the class and change the Open date when the class expired.
Thanks.
-
AuthorPosts
You must be logged in and have valid license to reply to this topic.