By Lucio Prieto Veramendi on Wednesday, 30 May 2018
Posted in General
Replies 5
Likes 0
Views 624
Votes 0
I want to optimize the loading of the web, is there any way to accomplish that? What I can do? some component? because from the server side, there are enough resources
I personal suggest you that consider to use mod_pagespeed from your server, it's actually an apache / nginx module that can be used to compress and minify a page on the web server's layer without compromising performance of php, so it will improve your site performance faster as well.

Then enabled Gzip compression from backend, it will reduces the file size of all scripts and css files being rendered on the page.

You can read more about mod_pagespeed from https://developers.google.com/speed/pagespeed/module/

Hope this alternative solution will help on your site.
·
Wednesday, 30 May 2018 15:02
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello gentlemen, my hosting provider has answered me like this:

Hello good afternoon

These indications are already applied in your hosting account.

On optimization, I see that you have the following tables with many records, I recommend that you review their content since they can make the operation of your website very slow.

If necessary, check the extensions that handle those tables and empty the tables that you can:

gaf2j_community_photo_stats ... has 110198 records in the Database: conexio2_10472
gaf2j_finder_terms ... has 173141 records in the Database: conexio2_10472
gaf2j_social_badges_history ... has 1750914 records in the Database: conexio2_10472
gaf2j_social_conversations_message ... has 297862 records in the Database: conexio2_10472
gaf2j_social_conversations_message_maps ... has 575554 records in the Database: conexio2_10472
gaf2j_social_notifications ... has 480905 records in the Database: conexio2_10472
gaf2j_social_photos_meta ... has 454608 records in the Database: conexio2_10472
gaf2j_social_points_history ... has 609411 records in the Database: conexio2_10472
gaf2j_social_stream_item_history ... has 120508 records in the Database: conexio2_10472

I hope that my answer has been useful, otherwise, let me know so I can continue to help you.

A greeting.
---
Best regards.
Salvador Gómez
·
Saturday, 02 June 2018 04:51
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey there,

I am really sorry for the delay of this reply as it is a weekend for us here.

Hm, it shouldn't cause the website very slow if there got large data from the database, imagine if you running a social network site, you can't predict how many data user submit story post, upload photo, conversation and etc, unless your webhosting provider can provide us more details which web page load extremely slow because of these table so we can able to check.

gaf2j_community_photo_stats ... has 110198 records in the Database: conexio2_10472

By the way, this table you can remove it if you no longer run Jomsocial on your site because this table is not under Easysocial.
·
Saturday, 02 June 2018 11:35
·
0 Likes
·
0 Votes
·
0 Comments
·
Can you help me, please ? on everything to eliminate the tables that are no longer used because they were Jomsocial. I thank you Greetings and have an excellent day
·
Sunday, 03 June 2018 00:43
·
0 Likes
·
0 Votes
·
0 Comments
·
Can you do the full backup first so I can help you removed those Jomsocial table on your site? e.g. gaf2j_community_xxx

But unfortunately these following table unable to remove data from your database, because Easysocial still needed these data populate on your site.

gaf2j_social_badges_history ... has 1750914 records in the Database: conexio2_10472
gaf2j_social_conversations_message ... has 297862 records in the Database: conexio2_10472
gaf2j_social_conversations_message_maps ... has 575554 records in the Database: conexio2_10472
gaf2j_social_notifications ... has 480905 records in the Database: conexio2_10472
gaf2j_social_photos_meta ... has 454608 records in the Database: conexio2_10472
gaf2j_social_points_history ... has 609411 records in the Database: conexio2_10472
gaf2j_social_stream_item_history ... has 120508 records in the Database: conexio2_10472
·
Monday, 04 June 2018 14:06
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post