PDA

View Full Version : Optimize Database?

blackberry
05-08-2013, 05:48 PM
Hi,

Is there anyway we can optimize / reduce the size of database?

What is the difference of pm and pmtext table?
dethfire
05-08-2013, 09:10 PM
just run the repair table command

pm stores the ids, pmtext stores the content
blackberry
05-09-2013, 01:08 PM
just run the repair table command

pm stores the ids, pmtext stores the content
Ok,

If i want to delete all the pm stored by users, I have to empty both tables?Right
dethfire
05-09-2013, 01:18 PM
Ok,

If i want to delete all the pm stored by users, I have to empty both tables?Right

That's correct. I've done it before.
ForceHSS
05-09-2013, 02:42 PM
admincp/users/Private Message Statistics
Chris8
05-11-2013, 05:17 PM
You could move avatars and other user uploaded images to file system if you have not already done that. That would reduce database size significantly.
blackberry
05-14-2013, 07:50 PM
admincp/users/Private Message Statistics
?? what do i do with it?

--------------- Added 1368564699 at 1368564699 ---------------

You could move avatars and other user uploaded images to file system if you have not already done that. That would reduce database size significantly.
Thanks, it is already on file system// my db size is 801.55MB :-s
ForceHSS
05-14-2013, 10:32 PM
?? what do i do with it?


Look at it and you will see