vb.org Archive - how to optemize the database to make it smaller

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

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

- - how to optemize the database to make it smaller (https://vborg.vbsupport.ru/showthread.php?t=105927)

stinger2

01-21-2006 08:35 PM

how to optemize the database to make it smaller

a general question

with time the database is growing too much which makes the maintenance and moving the site more difficult
so my question is
can we remove some unnecessary componants from it

like deleting all the PM and Pm text
deleting all log files
any other non essential parts ....to be rebuild again

just to make it more clear

for example
deleting PM as running this query
TRUNCATE TABLE pm
TRUNCATE TABLE pmtext
(answered in anoither thread)

i dont know though wether I should run these queries apart or as one

i mean
TRUNCATE TABLE pm

and hit run

then another query
TRUNCATE TABLE pmtext

or i paste both of them and excute as one as??

stinger2

01-24-2006 06:30 PM

PHP Code:


		
			
UPDATE `user` SET `pmtotal` = '0',`pmunread` = '0'; 

TRUNCATE TABLE `pm`; 

TRUNCATE TABLE `pmtext`; 

TRUNCATE TABLE `pmreceipt`;

queries are run one query at a time

got this answer from vbulletin.com just in case any one is also interested in this subject

credits to Steve Machol

All times are GMT. The time now is 10:49 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01750 seconds Memory Usage 1,708KB 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 (1)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (2)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: