MySQL Connections (want to buy vB)

[webmaster20923]

Hello,

i would like to buy vB 2, but i have to know if it would work with my provider ("Schlund & Partner").

The board i use at the moment counts about 10.000 Views/day.

And there are about 30-50 users online at the same time (last 10 minutes).

The limits of my provider are:

- max. 12.000- 15.000 Mysql Queries / hour
- max. 12 parallel Mysql connections

Is it possible may to run vBulletin on 2 Mysql databases?

thanks!

[George L]

4.167 queries per second!! and 12 max_connections

your host is very restrictive and you will have problems with any php/mysql based forum including vbulletin

i suggest you find a better host as that is very restrictive for any php/mysql forum script

as to 2 databases - you mean 1 vb forum using 2 databases ? vB uses 1 database for 1 installation

[webmaster20923]

I use at the moment a PHP4/MySQL board (dynamicboard.de) and i have at the moment about 2000 connections and 15.000 queries at the moment.

[George L]

with vB you can in config.php turn off persistent connections (pconnect = 0) to ease the 12 max_connections limit your host set

how many new posts/threads per day are you getting with those 50 users online ?

[webmaster20923]

Per day about 30 new threads and about 300 replys.

[George L]

Originally posted by webmaster20923
Per day about 30 new threads and about 300 replys.

hmmm you should be okay... but it's hard to say how different vB would perform compared to your current forum script in terms of mysql usage

also from my experience moving to vBulletin has the effect of increasing member activity since it's generally a faster forum script ...

my ezboard use to get 3900 posts in 10 months with 200 members

changing to vB i get 1300 - 2400 new posts each day and 30 - 150 new members per day

[webmaster20923]

How much queries will be done per 1 connect ?