Aplau
Level 1
Write the reason you're deleting this FAQ
Sudden jump in response time to a too low level of 6 days from a good response time of nearly 6 hours.
Anyone else facing similar problems like me? I have been watching this response time jumping from around 6 hours to 2 days earlier. It gets back in some hours to normal again. But this time it's gone too low beyond my imagination.
Now I'm downgraded from level 3 to level 1 for this bug. Waiting some hours to get back my original response time and deserved level for that. Still it's one unpleasant experience I got.
Are you sure you want to delete this post?
Are you sure you want to delete this post?
Are you sure you want to delete this post?
Are you sure you want to delete this post?
Are you sure you want to delete this post?
Are you sure you want to delete this post?
Are you sure you want to delete this post?
Are you sure you want to delete this post?
Are you sure you want to delete this post?
| Order | Response Time | Days ago |
| 1234 | 518400 seconds (6 days) | 30 |
| 2332 | 36000 seconds (10 hours) | 5 |
| 9982 | 3600 seconds (1 hour) | 1 |
| 8734 | 518400 seconds (6 days) | 2 |
| Totals | 1,044,000 seconds (12.08 days) |
It may appear to jump, but it is constantly changing. This is because 1) Order responses older than 30 days fall off and 2) Your response time is constantly changing based on new responses (even if that is only a few seconds or a few days).
[table][tr][td][b]Order[/b][/td][td][b]Response Time[/b][/td][td][b]Days ago[/b][/td][/tr][tr][td]1234[/td][td]518400 seconds (6 days)[/td][td]30[/td][/tr][tr][td]2332[/td][td]36000 seconds (10 hours)[/td][td]5[/td][/tr][tr][td]9982[/td][td]3600 seconds (1 hour)[/td][td]1[/td][/tr][tr][td]8734[/td][td]518400 seconds (6 days)[/td][td]2[/td][/tr][tr][td][b]Totals[/b][/td][td][b]1,044,000 seconds (12.08 days)[/b]
[/td][td][/td][/tr][/table]
Now, in the above example you have a total response time of 1,044,000 seconds. You have 4 orders that are being calculated. 1,044,000 / 4 = 261,000 seconds or 3.02083333 days.
Your response time is [b]3.02083333 days[/b]. Using that response time and the numbers above, consider these scenarios:
1) Tomorrow, you get an order and respond in 1 hour (3600 seconds). What is your new average? You may say 1,044,000 seconds + new response time of 3600 = 1,047,600 / 5 = 209,520 seconds or 2.425 days... You would be [b]incorrect[/b]. Notice the 1st order was 30 days ago and this scenario is tomorrow. The first order (6 days response time) would fall off and not calculate. Your new response time would be 561,600 seconds / 4 = [b]140,400 seconds[/b] or 1.625 days.
2) You don't receive an order tomorrow and make no responses. What is your response time? Answer: It remains the same, 3.02083333 days. Your score isn't updated until you have a new response to be factored.
So, I hope that helps everyone understand. I also was able to legitimately use the new tables in a response, so I am happy. :D
Are you sure you want to delete this post?
Are you sure you want to delete this post?
Ok
Thanks
Great. I'm starting your work now and will respond again once completed.No problem. I agree, that is an awkward situation and an unanticipated result of the response calculation. I've seen a lot of sellers just reply with something simple like: [quote]Ok[/quote] or [quote]Thanks[/quote] or [quote]Great. I'm starting your work now and will respond again once completed. [/quote]
Are you sure you want to delete this post?
My response time has been bouncing around a lot lately as well and I dropped from level 3 down to 1 because of it. I sent a ticket to support the first time it happened, but it was back to normal by the time I heard back.
Now I don't sweat it. It's obviously a glitchy system, but fixes itself fairly quickly. A couple days ago when my level dropped from 3 to 1 because my response time supposedly jumped from 11 hours to 6 days it only lasted a few hours before it was back to level 3 and the 11 hour response time I've actually had for months, as I'm online every day and I always respond quickly, except when sleeping, of course.
It's a flawed system, but it works itself out, so no biggie. Enjoy your day! :)
Are you sure you want to delete this post?
Are you sure you want to delete this post?
Are you sure you want to delete this post?
| Match | Count | SQL | Script |
| SELECT * FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='22428' | 1 | SELECT q.*, c.seo as CatSEO, c.name as CatName, c.parentid
FROM `questions` as q
JOIN categories_faq as c ON q.catid=c.CATID
WHERE (q.status=1 OR
(q.status=2 AND userid='')
)
AND q.quesid='22428' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='12836' | 1 | SELECT * FROM seoclerks.members WHERE USERID='12836' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=12836 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=12836 | /opt/clerks-staging/docroot/include/functions/main.php 16914 GetGooglePlusProfileFromId() () |
| SELECT * FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=22428 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faq as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=22428
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='22428' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc | 1 | SELECT a.answer, a.USERID, a.upvotes, a.downvotes, a.ansid, a.parentid, a.combined_votes, a.date_answered,
b.username, b.userlevel, b.profilepicture FROM answers a, seoclerks.members b
WHERE a.quesid='22428' AND a.userid=b.USERID and b.status='1' AND a.status=1
ORDER BY a.combined_votes DESC, a.date_answered asc | /opt/clerks-staging/docroot/viewfaq.php 1245 () () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=116622 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=116622
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=116623 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=116623
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=116627 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=116627
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=116634 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=116634
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=116635 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=116635
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=116637 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=116637
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=116638 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=116638
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=116621 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=116621
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=116641 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=116641
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=116643 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=116643
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=116650 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=116650
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=116653 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=116653
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=116654 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=116654
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=117984 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=117984
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=117986 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=117986
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=117991 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=117991
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='22428' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='22428' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='22428' AND status='1' AND (question like '%Response time bug jumping sudden%' OR question like '%Response%' OR question like '%time%' OR question like '%jumping%' OR question like '%sudden%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='22428' AND status='1'
AND (question like '%Response time bug jumping sudden%' OR question like '%Response%' OR question like '%time%' OR question like '%jumping%' OR question like '%sudden%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='2470' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='2470' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='1856' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1856' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='1915' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1915' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='7299' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='7299' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='3250' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='3250' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=22428%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID | 1 | SELECT USERID, username FROM members_ledger
WHERE script='/opt/clerks-staging/docroot/viewfaq.php'
AND querystring LIKE '%id=22428%'
AND added>=UNIX_TIMESTAMP(NOW())-1200
GROUP BY USERID
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM categories | 1 | SELECT * FROM categories | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache() |
| select * from categories_software order by name asc | 1 | select * from categories_software order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetSoftwareCategories() |
| select * from categories_wanttobuy order by name asc | 1 | select * from categories_wanttobuy order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_wantcategories() |
| select * from categories_wanttotrade order by name asc | 1 | select * from categories_wanttotrade order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_tradecategories() |
| SELECT * FROM seoclerks.members WHERE USERID='9.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='9.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='12836.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='12836.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='296516.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='296516.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='272.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='272.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='167023.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='167023.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| select * from categories_faq order by name asc | 1 | select * from categories_faq order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories() |
| count(*) | sql1 | error_msg |
|---|
| Load | Count | SQL | Max | Min |
| Avg Time | Count | SQL | Max | Min |
robertman11
Just for the sake of knowing, response time is calculated only on orders messages (not inbox) as such:
-- Buyer message (1:02)
-- Seller response (1:04)
-- Buyer message (1:10)
-- Seller response (2:10)
So, the seller responded to the first message in 2 minutes and the second one in 60 minutes. 60+2 = 62 / 2 = Average of 31 minute response time.
This is calculated by seconds rather than minutes but for simplicity sake, I used minutes above. This calculation is for every buyer/seller order message/response during a 30 day period. The 30 day period is not orders created during the last 30 days but responses by the seller during the last 30 days. A seller could respond to an order 1 year later and that response will be included in the calculation.
Hope that clears it up. There hasn't been any updates relating to response time. Usually this happens when a seller responds to an old order they forgot to respond to (or even complete, tsk tsk). Contact the Helpdesk if you think this is in error and a staff member will be able to analyze what caused it. Just for the sake of knowing, response time is calculated [b]only[/b] on [b]orders [/b]messages (not inbox) as such: -- Buyer message (1:02) -- Seller response (1:04) -- Buyer message (1:10) -- Seller response (2:10) So, the seller responded to the first message in 2 minutes and the second one in 60 minutes. 60+2 = 62 / 2 = Average of 31 minute response time. This is calculated by seconds rather than minutes but for simplicity sake, I used minutes above. This calculation is for [b]every[/b] buyer/seller order message/response during a [b]30 day[/b] period. The 30 day period is [b]not[/b] orders created during the last 30 days but [b]responses[/b] by the seller during the last 30 days. A seller could respond to an order 1 year later and that response will be included in the calculation. Hope that clears it up.
Are you sure you want to delete this post?