Hi everyone,
I just preloaded 70k profiles and the performance is really poor when I open the dashboard or my matches.
Have anyone had this problem and how was solved?
Thank you
We build. You grow.
Get best community software hereStart a social network, a fan-site, an education project with oxwall - free opensource community software
Poor performance | Forum
Wilson
Jul 31 '15
hey
Joaquin
Could be many things....
Try these links as it has be talked about before. Do a search as I just did!
1. http://www.oxwall.org/forum/topic/6569
2. http://www.oxwall.org/forum/topic/9384
3. http://www.oxwall.org/forum/topic/6289
4. http://www.oxwall.org/forum/topic/4409
5. http://www.oxwall.org/forum/topic/1925
6. http://www.oxwall.org/forum/topic/23900
Wilson
Joaquin
Aug 1 '15
Hi Wilson,
Thank you for your reply.
I read some of your links and others not listed. I even modified .htaccess as some people indicate in other posts that you didn't mention. But it does not seem to be related to any of the issues mentioned in this forum so far.
The problem seems to be more MySql related. Eventually my hosting provider HostForWeb got in touch with Skadate or the othe way round and they activated logs for MySql. In the end, I was told that the dashboard and the section "my matches" use a lot of SQL and that's why the system is slow to show those two screens in particular. I was adviced to adquire a higher hosting solution and I went for a 8Gb and 4 vCores VPS with the hope that this would solve the problem, but it did not.
In my opinion I don't think that 400k rows, not even 77k rows should be a problem for MySQL specially on a server like that. I also ruled out to got for even a bigger VPS or different solution, because I don't think that will solve the problem. Neither will leaving the system with only 10k rows.
Please help me with this issue as I've been stuck with this thing for a long time now.
Thank you
Joaquin
Thank you for your reply.
I read some of your links and others not listed. I even modified .htaccess as some people indicate in other posts that you didn't mention. But it does not seem to be related to any of the issues mentioned in this forum so far.
The problem seems to be more MySql related. Eventually my hosting provider HostForWeb got in touch with Skadate or the othe way round and they activated logs for MySql. In the end, I was told that the dashboard and the section "my matches" use a lot of SQL and that's why the system is slow to show those two screens in particular. I was adviced to adquire a higher hosting solution and I went for a 8Gb and 4 vCores VPS with the hope that this would solve the problem, but it did not.
In my opinion I don't think that 400k rows, not even 77k rows should be a problem for MySQL specially on a server like that. I also ruled out to got for even a bigger VPS or different solution, because I don't think that will solve the problem. Neither will leaving the system with only 10k rows.
Please help me with this issue as I've been stuck with this thing for a long time now.
Thank you
Joaquin
Team Taissa
Aug 4 '15
Joaquin, as I understood you are using SkaDate software. SkaDate has their own number of features which is not related to Oxwall and that is why I can't help you properly. For Oxwall the solution could be to configure Nginx, eAccelerator and memcached. This will reduce server load significantly.
But SkaDate has his own technical support so please contact them to solve your issue. Based on our experience I can recommend you to use VPS or dedicated server in this case.
But SkaDate has his own technical support so please contact them to solve your issue. Based on our experience I can recommend you to use VPS or dedicated server in this case.
