databank crashes with too many comments

Welcome, Guest. Please login or register.
Did you miss your activation email?

May 24, 2012, 07:18:05

JoomlaTune Support Forum

JComments component

Bug-reports

Topic: databank crashes with too many comments

Pages: [1] Go Down

	Author	Topic: databank crashes with too many comments (Read 1268 times)
0 Members and 2 Guests are viewing this topic.

genesis26

Newbie

Karma: 0

Offline

Posts: 3

databank crashes with too many comments

« on: December 05, 2010, 21:44:59 »

Hi

I have around 6000 articles with around 800000 comments and millions of votes. -- With the time the databank became slower and slower. Finally the whole site broke.

I had to delete all comments and votes - and then everything worked fine.

It seems, that there is a natural limit for comments, especially if u have slow servers.

Site: www.mmnews.de

BTW: could u contact me for donation - send me your bank account details


« Last Edit: December 06, 2010, 06:47:50 by genesis26 »	Logged

smart

Administrator
Hero Member

Karma: 160
Offline

Offline

Gender: Male

Posts: 2559

Re: databank crashes with too many comments

« Reply #1 on: December 06, 2010, 16:51:18 »

Quote from: genesis26 on December 05, 2010, 21:44:59

I have around 6000 articles with around 800000 comments and millions of votes.

Wow... I'm really impressed. At this time your site is the biggest JComments-powered site that I know. What server's hardware are you using? How many page views you've per day?

Quote from: genesis26 on December 05, 2010, 21:44:59

I had to delete all comments and votes - and then everything worked fine.

What happens if you'll delete only votes? Will it help?

Quote from: genesis26 on December 05, 2010, 21:44:59

BTW: could u contact me for donation - send me your bank account details

Ok, I'll contact you via PM