Newbie
Karma: 0
Posts: 7
|
 |
on: Oct 15, 08, 05:03 AM |
|
i have a website wich has about 20.000 uniques a day, it was hosted on a shared server,and i was making problems,like when you enter the site and click a game it loads in 7-8 seconds,now i moved it to a dedicated server with 2.2 dual core,and 3gb ram,and now it loads in 3-4 seconds,what do you recommend so the mysql wont load so much....
|
|
|
|
|
Logged
|
|
|
|
Administrator
Sr. Member
Karma: 7
Posts: 481
|
|
Reply #1 on: Oct 15, 08, 05:42 AM |
|
I'd suggest you to deactivate useless blocks on your pages like WHOLIKESGAME, "Joaca joc" cos they generate additional sql queries. And make sure that most of those 20000 are not SE robots... your site is only few months old, so most of traffic can be a junk search engines' queries (you can turn most of them off by editing your robots.txt)
|
|
|
|
|
Logged
|
|
|
|
Newbie
Karma: 0
Posts: 7
|
|
Reply #2 on: Oct 15, 08, 05:49 AM |
|
my website is not new,is one of the top of my coutryes at the query jocuri meaning games in translation,take a look at http://www.jocuri-tari.ro it`s hosted on a 200$ dedicated godaddy server i was thinking to make order by rand() in index so the games to be showed randomly but i cand find the line where i can do that,i only found order by rand() for categories |
|
|
|
« Last Edit: Oct 15, 08, 05:59 AM by kay »
|
Logged
|
|
|
|
Administrator
Sr. Member
Karma: 7
Posts: 481
|
|
Reply #3 on: Oct 15, 08, 06:29 AM |
|
Well, it does not actually matter how old your site is (I found its registration date at http://pwhois.rotld.ro which says the domain was registered in january 2008)... I'm here to help you and nothing else  To show random games on the front page you should edit the "GAMELIST" block's settings - switch the "Sorting" option to "Random". That's it, you don't have to edit the code. |
|
|
|
« Last Edit: Oct 15, 08, 07:04 AM by Sergey »
|
Logged
|
|
|
|
Newbie
Karma: 0
Posts: 7
|
|
Reply #4 on: Oct 15, 08, 06:49 AM |
|
believe me it has about 15.000-20.000 a day you will see the stats theese days... i will try,i want to make it work because i like verry much,and i dont want to change it because i m sorry that i have paid it.
edit: i have modified and nothing happend,still working bad...
|
|
|
|
« Last Edit: Oct 15, 08, 07:00 AM by kay »
|
Logged
|
|
|
|
Administrator
Sr. Member
Karma: 7
Posts: 481
|
|
Reply #5 on: Oct 15, 08, 07:10 AM |
|
yeah, 20 000 is quite a large number... I hope your flasharcade is the only website running on that dedic. server? If it is, there must not be a problem with the script, it had been tested (and is running now) on even higher traffic.
|
|
|
|
|
Logged
|
|
|
|
Newbie
Karma: 0
Posts: 7
|
|
Reply #6 on: Oct 15, 08, 07:13 AM |
|
the domain is single on the dedicated server,and i have tried it on two dedicated one in romaina and one at godaddy,and sincerly it s running verry hard.what can i do?
|
|
|
|
|
Logged
|
|
|
|
Administrator
Sr. Member
Karma: 7
Posts: 481
|
|
Reply #7 on: Oct 15, 08, 07:31 AM |
|
to encrease your site's speed you can also descrease the graphics size - the header weights too much. Attached are simpler footer and header.
Please let me know once your site is back online (now I see only the Fedora Test Page) so I can check how it's loading.
|
|
|
|
Logged
|
|
|
|
Newbie
Karma: 0
Posts: 7
|
|
Reply #8 on: Oct 15, 08, 07:57 AM |
|
script change... wasted money on proarcade script,please reconsider in reediting it for higher trafic and low mysql load.. check now the website to see the differences...
|
|
|
|
|
Logged
|
|
|
|
Administrator
Sr. Member
Karma: 7
Posts: 481
|
|
Reply #9 on: Oct 15, 08, 08:13 AM |
|
I didn't saw it while it was in troubles to compare, so can't say anything about the change... As for your problem with mysql... well, that's strange, personally I don't have any problem with a high-loaded proarcadescript-based site hosted on even cheaper dedicated server ($79/mo Intel DUAL CORE with 2Gb ram)
|
|
|
|
|
Logged
|
|
|
|
Customers
Jr. Member
Karma: 2
Posts: 23
|
|
Reply #10 on: Nov 15, 08, 07:39 AM |
|
You need to edit in Page Blocks/Related Games that line: // how old (days) must be the data to be considered as obsolete $cRelatedDays = 7; I changed that to // how old (days) must be the data to be considered as obsolete $cRelatedDays = 1; And all speed problems is solved |
|
|
|
|
Logged
|
|
|
|
|
