vb.org Archive - Optimize Database?

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Optimize Database? (https://vborg.vbsupport.ru/showthread.php?t=297950)

blackberry

05-08-2013 05:48 PM

Optimize Database?

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

Quote:

Originally Posted by dethfire (Post 2420778)

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

Quote:

Originally Posted by blackberry (Post 2420859)

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

Quote:

Originally Posted by ForceHSS (Post 2420875)

admincp/users/Private Message Statistics

?? what do i do with it?

--------------- Added [DATE]1368564699[/DATE] at [TIME]1368564699[/TIME] ---------------

Quote:

Originally Posted by Chris8 (Post 2421353)

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

Quote:

Originally Posted by blackberry (Post 2422076)

?? what do i do with it?

Look at it and you will see

All times are GMT. The time now is 08:01 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01213 seconds Memory Usage 1,720KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (8)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: