Everett
Level X4
Write the reason you're deleting this FAQ
Why I initially bought a dedicated server (the back story).
Generally I buy cheap hosting packages. And when I mean cheap.. I mean cheap! For instance, currently I have a shared hosting plan that costs, wait for it, .. $1.50 a month.
Here's the specs for my $1.50 a month plan:
Are you sure you want to delete this post?
| Match | Count | SQL | Script |
| SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400 | 1 | SELECT querystring, added
FROM members_ledger
WHERE
ip = ? AND added>=unix_timestamp(NOW())-86400 | /opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once() |
| 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='20964' | 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='20964' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='2951' | 1 | SELECT * FROM seoclerks.members WHERE USERID='2951' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=2951 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=2951 | /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=20964 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=20964
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='20964' 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='20964' 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=113869 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=113869
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=113920 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=113920
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='20964' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='20964' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='20964' AND status='1' AND (question like '%Dedicated Servers: experience renting unmanaged server experience%' OR question like '%Dedicated%' OR question like '%Servers:%' OR question like '%experience%' OR question like '%renting%' OR question like '%unmanaged%' OR question like '%server%' OR question like '%experience%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='20964' AND status='1'
AND (question like '%Dedicated Servers: experience renting unmanaged server experience%' OR question like '%Dedicated%' OR question like '%Servers:%' OR question like '%experience%' OR question like '%renting%' OR question like '%unmanaged%' OR question like '%server%' OR question like '%experience%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='4241' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='4241' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='29534' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='29534' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='43' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='43' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='2077' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='2077' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='19120' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='19120' 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=20964%' 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=20964%'
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='2951.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='2951.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 |
virusblock
Once i was using ASP-Net to host pages for me and a fake email from the FBI got me closed down because i had upset a very big household name and they sent the gang after me, well professorial and to read the email you would be convinced yourself but after i asked them to check it out they put me back on line and a week later they fell for another scam letter so i gave in paying for services like that.
Can you not host your site from home ?
Mine runs red-hot at times, like 1tb of BitTorrent seeds a month and now and then one million hits an hour on my proxy -server that does some heavy caching to keep up plus someone here is always watching something on Youtube and then we have X-Boxes too and all using a domestic 80meg link with no limit's else i would not be doing it.
You can fudge domains using Dynamic DNS to keep your traffic hitting the right box I tend to work windows based (yes i know) and these servers offer the earth but they are using virtual servers and they only give you about 0.5% of CPU time-slice and you can get into lots of trouble because i've seen server-side VB script in the old ASP pages running some real strange version of script that would not even compile to run. Once i was using ASP-Net to host pages for me and a fake email from the FBI got me closed down because i had upset a very big household name and they sent the gang after me, well professorial and to read the email you would be convinced yourself but after i asked them to check it out they put me back on line and a week later they fell for another scam letter so i gave in paying for services like that. Can you not host your site from home ? Mine runs red-hot at times, like 1tb of BitTorrent seeds a month and now and then one million hits an hour on my proxy -server that does some heavy caching to keep up plus someone here is always watching something on Youtube and then we have X-Boxes too and all using a domestic 80meg link with no limit's else i would not be doing it. You can fudge domains using Dynamic DNS to keep your traffic hitting the right box
Are you sure you want to delete this post?