SMF Support > SMF 1.1.x Support

how to improve database performance

<< < (2/3) > >>

Arantor:
Depends on your definition of 'without problems'. The fact it will screw performance up even more to empty it periodically is really a problem, isn't it?

hellboy78:
oh well,

always unclear answers from you.

I have found inside this same forum that a lot of users empty the smf_sessions table to save some space,

I asked you if I can empty the smf_prettyurl_cache without problems, and you give an unclear answer.

the smf_prettyurl_cache can be cleared using the "maintenance" of pretty url, into admin section,
are you telling me that click "maintanance" button will make problems?

I'm trying to run a very huge forum here.

Arantor:
I give you an unclear answer because it's a lot of complexity, there's a lot of different things at work. The whole point of the table is to save processing work later on - clearing the table will cause other processing, so you're not saving anything, you're trading when work gets done.

I can't make this any clearer that I already have done multiple times: DO NOT EMPTY ANY TABLE UNLESS YOU KNOW WHAT YOU ARE DOING. YOU DO NOT KNOW WHAT YOU ARE DOING, SO DO NOT EMPTY ANY TABLE!

Clicking maintenance will not cause problems in itself, all that will happen is the forum will start to create more rows, doing it occasionally is fine, because all that happens is you get a slowdown for a period immediately following it while the database is rebuilt. Doing it regularly means you rebuild the database regularly which will overall slow it down.

Oh, and a forum with 20MB of posts is not a huge forum, not by any stretch of the imagination. It's, what, 20,000 posts? Wait until you start dealing with multi-million post forums, with GBs of data everywhere.

hellboy78:
you probably don't get the point,

I'm running an adult website, with 18.000 members,
I'm going to keep the first position on google for 3 keywords,
could you imagine what can it happen if my forum arrives there?
is it ok for you if I try to understand all process about my forum?
if I cannot handle any future problem, I may lose an great opportunity,
anyway, my forum is not FREE, so if a user pay me...I have to run the forum very well.

that's why I ask around everything and try to have a perfect solution to run the forum for a long time.

anyway, be into first page of google cost me a lot of money,
I cannot make mistakes

thanks

Arantor:

--- Quote ---you probably don't get the point,
--- End quote ---

You probably don't get the point. You're fumbling around trying to change things and you have no idea of the consequences, and even when I tell you multiple times that there are things you shouldn't do, you continue to keep asking about them because you obviously know better than I do (hint: I've been using PHP for 9 years, SMF for 6 years, I'm formerly a member of the SMF Customizer team, the helpdesk being used on this site was written by me, and more than one bug in SMF 2.0 was fixed by me, suffice to say I know about running SMF and customising it)


--- Quote ---could you imagine what can it happen if my forum arrives there?
is it ok for you if I try to understand all process about my forum?
--- End quote ---

That would be fine if you were actually asking about that. Instead, you're asking whether it's OK to mess with things that should not be messed with, even when I tell you not to. At least twice you've asked about pruning the smf_messages table for example... the table that actually contains the forum content, and twice I've had to tell you to leave it alone.

Perhaps I should let you empty the smf_messages table, maybe you'll get the point then that you're not supposed to just randomly empty things out in the hopes of making things fast. It won't make it fast, it'll break things.

If you really want to improve performance, follow http://www.simplemachines.org/community/index.php?topic=293441.0 and the tips therein - written by people who have much bigger forums than you.

But you're more willing to listen to second-rate programmers who have no knowledge of SMF than someone who is actually knowledgeable about SMF. Have fun, I'm done trying to help you because no matter what I do, you're going to continue to ignore what I've been trying to tell you.

Navigation

[0] Message Index

[#] Next page

[*] Previous page