vb.org Archive - Help with a DB

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

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

- - Help with a DB (https://vborg.vbsupport.ru/showthread.php?t=290517)

gmata

11-11-2012 08:04 PM

Help with a DB

Hello,

I have a DB that is almost 1gb in size, it contains mostly pictures from the User Albums, i allowed any size of picture to be uploaded and a lot of users uploaded pictures of up to 10 mb in size. The Db got soo big that it was causing problems with the performance of the site and i had to removed them. I was wondering if there is any way to acces all those file and resize all the images and upload them again into my forum.

thanks in advence for the help.

Gonzalo

Chris8

11-11-2012 09:17 PM

Not sure if there is a way to do it within database but you could for temporary move them to file system, resize them with some gfx software e.g. Photoshop and then move them back into DB, But I guess it would be heavy process. Then again after some time you will have same problem. Isn't it a better idea to move them into the file system permanently?

Simon Lloyd

11-12-2012 12:08 AM

Quote:

Originally Posted by Chris8 (Post 2380367)

Isn't it a better idea to move them into the file system permanently?

Definitely, you hit the nail on the head!

All times are GMT. The time now is 11:22 AM.

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