The Arcive of Official vBulletin Modifications Site.

Database question for you Big Boarders · **Released**: 01-13-2007

We are moving to a server that currently only has SQL installed on the server. The tech team is modifying vbulletin somewhat to match the SQL database. I am concerned about doing this so I decided to come here and ask. Do you guys run your forums on a SQL database or a MySQL database? Also, if you run it on a MySQL database, is there any issue in running MySQL and SQL side by side on the same server? Thanks for responses.

alexi · #2 01-13-2007, 11:09 PM

I am aware of one vbulletin owner that modified VB to run on postgresql. I have never heard of anyone doing it on MS SQL.
As for running the two side by side there's nothing that will inherently stop you but if your forum gets any kind of business I think your going to have major performance issues fairly quickly

FockerFGAA · #3 01-13-2007, 11:27 PM

i c. right now we pull around 30 to 40 users online at a time. we have a merger coming up and the way we have been growing recently im expecting closer to 100 when its all said and done. i know that doesnt require a significant server and we have a server lined up but it has sql on it. we want to be able to grow so the really cheap shared hosting you can buy is out of the question, but its not really worth it to fork out hundreds of dollars for a dedicated server each month. im trying to find something that has mysql on it and allows us to grow.

alexi · #4 01-14-2007, 12:13 AM

you should be able to handle 100 users pretty easily.
I should have asked, is the SQl doing anything or just installed?
If it's just installed set the services to never start and you'll be fine.

FockerFGAA · #5 01-14-2007, 12:28 AM

nah its doing something. its running multiple other boards. im starting to look into vps solutions. i think perhaps going with a vps that allows mysql might be better. itd take us a lot more users to max out a good vps

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03948 seconds Memory Usage 2,231KB Queries Executed 20 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (5)post_thanks_box (5)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (5)post_thanks_postbit_info (4)postbit (5)postbit_onlinestatus (5)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!