vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Multi Databases? (https://vborg.vbsupport.ru/showthread.php?t=213880)

stunod 05-17-2009 01:35 AM

Multi Databases?
 
I was just curious if it is possible to have more then just one database in vbulletin?

Maybe one just for images?

Thanks,
Adam

Lynne 05-17-2009 02:20 AM

You could have another database, however if you put some of the vbulletin tables into the new one (and delete them from the old one), then you will have to modify all the code that queries any of those tables. That wouldn't be something easy to do. What would you hope to gain from this?

stunod 05-18-2009 05:57 AM

My host "1and1.com" only offers a 100mb database and I have 25 of them available at 100mb, but it didn't take long to fill it up.

They offer a dedicated server with a bigger database for $120 a month. But I have been trying to avoid that!

I have been on the hunt for something to lower my database for sometime, but my attachment database is taking about 80% of my 100mb.

Adam

Dismounted 05-18-2009 06:54 AM

Change your Attachment Storage Type to "File System".

Lynne 05-18-2009 03:00 PM

Quote:

Originally Posted by Dismounted (Post 1812790)
Change your Attachment Storage Type to "File System".

And after you do that, make sure to run repair/optimize on your attachment table to reduce the size.


All times are GMT. The time now is 07:01 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01005 seconds
  • Memory Usage 1,712KB
  • 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
  • (5)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