?
avatar sandrodz
sandrodz
4 Nov 2015

Hello,

I've dataset of 90,000 articles. 800,000 comments. And 28,000 tags. With traffic of 100,000 visitors per day.

System was getting by on J 1.5 + varnish. Since we upgraded to 3.4 J and tried to use J native caching things started to fall apart.

New article manager is very slow, I had to archive most of the articles, leaving only 10K in active state. Before archiving article manager wouldn't even load.

I'm curious if there is anyone in the community with similar big data experience? If there are any topic related known issues that can help?

avatar sandrodz sandrodz - open - 4 Nov 2015
avatar zero-24 zero-24 - change - 4 Nov 2015
Labels Added: ?
avatar sandrodz
sandrodz - comment - 5 Nov 2015

I'm willing to share dataset if someone in J community is willing to take a look.

avatar Bakual
Bakual - comment - 5 Nov 2015

@alikon @gunjanpatel Something for you guys :smile:

avatar alikon
alikon - comment - 6 Nov 2015

@sandrodz could you please ping us https://volunteer.joomla.org/working-groups/sql-optimization-working-group or via glip
we would like to investigate this a bit further

avatar gunjanpatel
gunjanpatel - comment - 6 Nov 2015

Yes that will help a lot @sandrodz Thank you guys.

avatar sandrodz
sandrodz - comment - 6 Nov 2015

I've registered at glip: sandrodz[@]gmail.com (in-house we use slack) please invite me to your group :)

avatar alikon
alikon - comment - 6 Nov 2015

you have been invited now
we can close this one

avatar zero-24 zero-24 - change - 6 Nov 2015
Status New Closed
Closed_Date 0000-00-00 00:00:00 2015-11-06 12:19:04
Closed_By zero-24
avatar zero-24 zero-24 - close - 6 Nov 2015

Add a Comment

Login with GitHub to post a comment